Record Locking

[jeffrey]

I have a database that many users enter data into -
however, I want to be able to prevent users from entering
data into certain records after a time. Any suggestions
on how to make certain records editable and other not-
editable?

Thanks.

 

[AndyB]

Obviously you need a flag or a datestamp of some kind to
decide whether the record is editable.
Then you have several options:
You can set the allowedits property of the form using the
onCurrent procedure using and If Then Else structure.
me.allowEdits = false
Alternatively you could loop through all the controls on
your form and lock each one individually using the same
If Then Structure as above OnCurrent

dim ctl as Control
for each ctl in me.controls