I am trying to have a label become Visable and turn off additions and deletions when the check box is true. also i have never written in SQl before but here is the code I currently have.
Private Sub CheckLock()
If chkLocked = True Then
lblLocked.Visible = True
Me.AllowDeletions = False
Me.AllowEdits = False
Else
lblLocked.Visible = False
Me.AllowAdditions = True
Me.AllowEdits = True
End If
End Sub
a few other things
1: chkLocked is 100% sure the field name
2. it is definitely reading it as true
3. this is ran on an OnActivate for the form
4. it treats forms with check box checked the same as forms where the check box is not checked