Sorry Guys

When I implement Allan's code it works perfect apart from, the record is not
locked until next time the record is displayed/opened. I would like the
record to be locked Immediately, Any ideas. I,m going to set the enabled
values to flase to show a visual indication (Greyed Out), would that be ok?

Regards

John

To lock it immediately call the same code in the AfterUpdate event of the
form:
Private Sub Form_AfterUpdate()
Call Form_Current
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Sorry Guys
>
> When I implement Allan's code it works perfect apart from, the record is
> not locked until next time the record is displayed/opened. I would like
> the record to be locked Immediately, Any ideas. I,m going to set the
> enabled values to flase to show a visual indication (Greyed Out), would
> that be ok?

Thanks Again Allen
Regards
John
"Allen Browne" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> To lock it immediately call the same code in the AfterUpdate event of the
> form:
> Private Sub Form_AfterUpdate()
> Call Form_Current
> End Sub
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "John" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Sorry Guys
>>
>> When I implement Allan's code it works perfect apart from, the record is
>> not locked until next time the record is displayed/opened. I would like
>> the record to be locked Immediately, Any ideas. I,m going to set the
>> enabled values to flase to show a visual indication (Greyed Out), would
>> that be ok?
>
>