If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Skip Records on a Form
I have form based on a table. The table is appended daily with new records.
The goal of the form is to provide a place where people can view the new records and input data into the records. The problem I have is that the form is displaying old records as well as new. I want the form to display only new records that have not been updated by the user through the form. Any idea how I could acheive this? Thanks in advance. |
#2
|
|||
|
|||
Skip Records on a Form
How do you differentiate between "old" and "new" records? I.e. what
attribute of a record tells you (or more appropriately, tells Access) when a record is no longer "new"? You mention "updating by the user." What does that involve and how do you identify records which have been "updated by the user through the form"? It is quite likely that the answer to that question will tell you what criteria you need to apply to the form to filter out those records. George "WildlyHarry" wrote in message ... I have form based on a table. The table is appended daily with new records. The goal of the form is to provide a place where people can view the new records and input data into the records. The problem I have is that the form is displaying old records as well as new. I want the form to display only new records that have not been updated by the user through the form. Any idea how I could acheive this? Thanks in advance. |
#3
|
|||
|
|||
Skip Records on a Form
On Thu, 15 Apr 2010 07:15:01 -0700, WildlyHarry
wrote: I have form based on a table. The table is appended daily with new records. The goal of the form is to provide a place where people can view the new records and input data into the records. The problem I have is that the form is displaying old records as well as new. I want the form to display only new records that have not been updated by the user through the form. Any idea how I could acheive this? Thanks in advance. If you set the form's Data Entry property to True, the user will see only the blank new record and any records that they have entered since the form was opened (i.e. if they close Access and go to coffee break, when they open Access again they'll see a blank form). If you mean "records added today" then you'll need to base the form on a query selecting only those records, using a criterion on some value in the table (perhaps a date-added field). -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|