Display of records

[Bob Vincent]

In my application the data entry person will complete a form that adds
information to exising records in an underlying table. Based on advice I
received here I am limiting the records they can see by use of a combo box
with the limit to list value set to yes. I would like to prevent the data
entry person from being able to view, or edit, a record once it has been
edited one time. In other words they can pull it up once, add data to the
blank fields, but once they exit the form I don't want them to be able to
pull it up again.

 

[Alicia]

How about in the on current event you could loop through the controls and set
the locked property to true for all textboxes that are not null?

Or add a field to the main table and mark each record after it has been
edited?