Allan and Douglas Re MsgBox

  • Thread starter Thread starter John
  • Start date Start date
J

John

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
 
Thanks Again Allen
Regards
John
Allen Browne said:
To lock it immediately call the same code in the AfterUpdate event of the
form:
Private Sub Form_AfterUpdate()
Call Form_Current
End Sub
Click to expand...
 
Back
Top