G
Guest
I want to lock or unlock the records so that I do not delete or change any
record accidently, please help.
record accidently, please help.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Arvin Meyer
Muhammad U. Ameen said:I want to lock or unlock the records so that I do not delete or change any
record accidently, please help.
Something like this will work:
Private Sub txtUnitCode_AfterUpdate()
Me.txtUnitCode.Locked = True
End Sub
Private Sub Form_Current()
If Len(Me.txtUnitCode & vbNullString) > 0 Then
Me.txtUnitCode.Locked = True
Else
Me.txtUnitCode.Locked = False
End If
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access