after update disallow access to a field

  • Thread starter Thread starter Debby Turner
  • Start date Start date
Don't even give them access to the table with the data. You can create a
form where data entry is set to Add, where they enter the data, commit the
form, which in turn adds the new data to the table. This would be the
easiest way. However, if they made a mistake on the original data entry,
then someone else will have to go back and correct their mistake(s).
 
Thank you. We're trying to make it to hard.
-----Original Message-----
Don't even give them access to the table with the data. You can create a
form where data entry is set to Add, where they enter the data, commit the
form, which in turn adds the new data to the table. This would be the
easiest way. However, if they made a mistake on the original data entry,
then someone else will have to go back and correct their mistake(s).

--
G Vaught




.
Click to expand...
 
Most controls, such as a text box, have an enabled property and a locked property.
One way I accomplished this same task was to actually use two forms, one form that is not bound to a table for data entry. Then a second form for viewing that is bound to your table. In the second form's load event type

Me.controlname.Locked = True
Me.controlname.Enabled = False

You'll also have to use code in the first form to add the record to the table.

Such as this in a command button click event

Dim rs as Object
Set rs = CurrentDB.OpenTable "tablename"
rs.add
me.fieldname = rs.fieldname
rs.update

hope this helps.
 
Back
Top