Lock Old Records

[wizcow]

Hi
I have code that unlocks my invoice form when it opens to a new record.

If the user changes his mind and navagates back to the previous record the form is still unlocked.

How can I code the form to lock again?

Thanks
Tom

 

[Fizzio]

On the On_Current event of the form

If Me.NewRecord then
your unlocking code
Else: your locking code
End If

HTH