Lock a record after change in data

[DPACAccessWiz]

I have payroll application where I would like to lock one record at a time when a Yes/No field has been changed.

I would also like to lock that record based on a users security level.

 

[brucerichards]

Once the field has been ticked, you need to force a save (i.e. form requery) and the reopen the form, without closing it as read-only.

e.g.


Forms("MyForm&quot.Requery
DoCmd.OpenForm MyForm, , , MyUniqueID = CurrentUniqueID , acFormReadOnly

The record will now be locked.. Obviously check you can test the user id as to whether you force this..