lock subform record once added

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a database used to certify pallets for work orders. The main
form for the database has the work order information in the form, and all
pallets associated to that work order in the subform. I want all of the
pallets to be viewable, but once the data has been added by a worker, will be
unable to change it. What would be the best way in which to do this?
 
Set the subform's AllowEdits property to No.
Leave its AllowAdditions property at Yes.

You can now add new rows, but not edit existing ones.

You may want to set AllowDeletions to No as well.
 
Back
Top