data query

  • Thread starter Thread starter Spring
  • Start date Start date
S

Spring

I have one form I am using for users to update info for their records.
since the record is large, so the users want that Form can prompt an
indicator where to start whenever user has to come back finishing it.
I am thinking to add a field of "update_status =yes" to the record set
whenever the record been updated. So next time when users come back in
the form will prompt a record indicator to start where "update_status
<>yes".Help is appreciated to show Sql statements to loop through the
data record to find "update_status <>yes" to start?
 
Instead of basing the form on the table directly, create a query that
filters the records and use that for the record source of the form:

SELECT * FROM
WHERE [update_status]=False;

This assumes your [update_status] field is a Yes/No field, which actually
contains either True or False.

Carl Rapson
 
Back
Top