Lock the controls and subforms when user moves to the next record

[evander]

Hi everyone!

I have a form and a subform. What I want is to lock the controls of the form and its subforms when the user moves away from the current record of the main form, so that the user is prevented from editing its historical entries.

I have tried using the "Data Entry" property of a form, but its behavior is different from what I want to achieve.

Hoping to receive replies.
Thanks!

Joe

[evander]

I also want the form's controls and subforms to be enabled again when the user creates a new record.

[evander]

I just discovered the On Current event. Hope this works for me

[RuralGuy]

You are solving your problems faster that we can respond. You will get a Current Event *every* time as you move to a record.

[evander]

Thanks for responding RuralGuy.

[RuralGuy]

You are welcome. Glad to hear you solved your issue.