How to lock entry

[Kreso]

I have a database with few connected tables, and I have a true/false
checkbox in one table.
Is it possible to lock that row when checkbox iz turned on "true" so the
data only in that row cannot be edited?

Thanks

[Allen Browne]

If you use a form, you can prevent the records from being edited if the
IsLocked field is Yes, by putting code like this into the Current event
procedure of your form:

Private Sub Form_Current()
Dim bLock as Boolean
bLock = Nz(Me.IsLocked, False)
If Me.AllowEdits = bLock Then
Me.AllowEdits = Not bLock
End If
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.

"Kreso" <vi******@gmail.com> wrote in message
news:e7**********@ss408.t-com.hr...

I have a database with few connected tables, and I have a true/false
checkbox in one table.
Is it possible to lock that row when checkbox iz turned on "true" so the
data only in that row cannot be edited?

Thanks

[Kreso]

Thank you very much, it works!

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:44***********************@per-qv1-newsreader-01.iinet.net.au...

If you use a form, you can prevent the records from being edited if the
IsLocked field is Yes, by putting code like this into the Current event
procedure of your form:

Private Sub Form_Current()
Dim bLock as Boolean
bLock = Nz(Me.IsLocked, False)
If Me.AllowEdits = bLock Then
Me.AllowEdits = Not bLock
End If
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.

"Kreso" <vi******@gmail.com> wrote in message
news:e7**********@ss408.t-com.hr...

I have a database with few connected tables, and I have a true/false
checkbox in one table.
Is it possible to lock that row when checkbox iz turned on "true" so the
data only in that row cannot be edited?

Thanks