Quote:
Originally Posted by elderboy02
Ha ha brother. You too have the VBA rage  |
I graduated with a double major in accounting and finance. I did this because I know I don't have the patience for programming
PS - I ran into another 424 error.
Quote:
Private Sub chkOther_AfterUpdate()
'Verify Other capability
If [chkOther] = Yes Then
DLookup("[Other]", "tblUserPCE", "UserID = '" & Forms![frmNewUser]![strCurrentUser] & "'") = Yes
Else: [chkOther] = ""
MsgBox "You may not create a user that can authorize Other issues"
End If
End Sub
|
If the DLookup returns "No" then there is no error. If the DLookup returns "Yes" then I receive a '424' error.
Posted via Mobile Device