Skip Records in a Form

  • Thread starter Thread starter WildlyHarry
  • Start date Start date
W

WildlyHarry

I have a form in my database based on a table. The table is appended with
new reocrds everyday. My goal is to have the form present only the new
records and allow a user to key data into the new record and be recorded in
the same table. The issue I have is that the form is displaying all records
not just the new. Does anyone know a way to open a form and display only
those records that have not been updated by the user? Thanks in advance
 
Add a column for UpdateDate and update this column whenever a record is
updated via the form.
Set up a query to read all the rows/columns in the table where the
updatedate is null
SELECT * FROM MyTable WHERE UpdateDate IS NULL.
Base your form on this query and not the table.

-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
WildlyHarry said:
I have a form in my database based on a table. The table is appended with
new reocrds everyday. My goal is to have the form present only the new
records and allow a user to key data into the new record and be recorded in
the same table. The issue I have is that the form is displaying all records
not just the new. Does anyone know a way to open a form and display only
those records that have not been updated by the user? Thanks in advance
Click to expand...

http://groups.google.com/group/microsoft.public.access/browse_thread/thread/2bedf8fc0d763ec9?hl=en#
 
Back
Top