G
Guest
I USED TO WORK WITH DLOOKUP WITH ONE CONDITION TO SHOW SOME DATA BUT I DO NOT
HAVE PROBLEM FOR THIS BUT I WANT TO SHOW SOME DATA WITH USING DLOOKUP WITH
THRE CONDITIONS FOR EXAMPLE:
Dim Show As Boolean
Show = DLookup("SSHOW", "UsersPermission", "[UserName] =
Forms![Main]![SUserName]" And [formName] = Me.formName)
If Show = False Then
MsgBox " You dot not have permission to run this form "
DoCmd.Close
SO WHEN I DO THIS FUNCTION I GOT ERROR BUT I DO NOT KNOW THE REASON SO I
NEED HELP
HAVE PROBLEM FOR THIS BUT I WANT TO SHOW SOME DATA WITH USING DLOOKUP WITH
THRE CONDITIONS FOR EXAMPLE:
Dim Show As Boolean
Show = DLookup("SSHOW", "UsersPermission", "[UserName] =
Forms![Main]![SUserName]" And [formName] = Me.formName)
If Show = False Then
MsgBox " You dot not have permission to run this form "
DoCmd.Close
SO WHEN I DO THIS FUNCTION I GOT ERROR BUT I DO NOT KNOW THE REASON SO I
NEED HELP