lock field after data input

[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 ...

 

[DM]

set the form to open in blank format

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

 

[J_Goddard via AccessMonster.com]

You could do what you are asking, but it wouldn't work, because the changes
would not be a part of the data, so that the next time the form was opened
you would face the same problem.

If your form is used only to enter new data, set its Data entry property to
"Yes", so that existing records will not be seen when the form is opened.

John

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 ...

--
John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca

Message posted via AccessMonster.com

 

[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.