Having a Senior Moment!
On my Login form I am trying to get the status of a user. Form and checkbox are unbound.
tblUserSecurity_Sec
userID is the UserName.
Field (Active) Data Type is Number, Field Size is Integer
CheckBox is (chkactive)
Thanks for your time.
On my Login form I am trying to get the status of a user. Form and checkbox are unbound.
tblUserSecurity_Sec
userID is the UserName.
Field (Active) Data Type is Number, Field Size is Integer
CheckBox is (chkactive)
If DLookup("[Active]", "tblUserSecurity_Sec") = -1 And [userID] = (Me.txtUserID) Then
Me.chkactive = -1
End If
Thanks for your time.