lock subform record once added

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

 

[Allen Browne]

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.

 

[Guest]

Thanks very much! That solution solved the situation perfectly. Very Much
appreciated =)