lock field after data input

B

Bevins

Hi,
I designed a database where I do a majority of the data entry, but
other people occassionally enter data as well. I've noticed that
people sometimes open a form to enter new data, and they start typing
on the first record in the form instead of opening a new record. Is
there a way I can lock a field in a form after the data has been
entered (i.e. not lock the entire field, but make it impossible to
change the field after data has been entered in it once)? Hopefully
this makes sense ...
 
D

DM

set the form to open in blank format

go into design view open the form properties and select yes for data entry.
 
D

DM

forgot to explain this:

this as I mentioned will open the form in blank format and the user will
start with a blank form but will continue with each entry, meaning they can
go back to previous entries. when they exit and reopen, it starts over
again.

if you like to use the form to search through entries, create a copy for
inputting only and tell the other users to use that one and replace no in
the data entry properties on your form and you have it back for searching.
 
Top