Locking records in order form

[k_c_morrissey]

I have and order entry/lookup form with a subform to view the line items on the order.
Once an order has been saved and status is ‘placed’ I want the records for that order to be locked.

I would also like to display a message box with a yes/no answer to confirm that they want to issue the order and if they confirm then lock the record otherwise return them to the open order.

I can't find out how to do this, but I'm sure it can be done.

Any help will be gratefully accepted.

 

[PARSO]

do you mean lock it from everybody including admin, or just the users?

 

[k_c_morrissey]

Just the users of the form so that they can't accidentally change the data.

 

[PARSO]

assuming that the admin will be the ones entering data, and users will just be reading it.
check out this sample database, as it lets you restrict write access to different user groups...Try this...