Dlookup function using OR criteria for one field

[jdashm]

Having some difficulty with this syntax. Could someone help me clean this up.
I need to allow users to open a form if there user role is one of two roles.
My code runs but it doesn't recognize the criteria correctly .
Here is what I have written as of now...

If (DLookup("strUserRole", "tblUserLogin", "[strUserID]='" & Forms![_frmLoginVerify]!txtLoginName.Value & "'")) = " 'Consultant' & Or & 'PSR_A' " Then

Thanks in advance for your help.

[ranman256]

You don't need the .value

you can't use 1 statement = a or b, it must be...
staetement=a or statement=b

[jdashm]

Thanks... I took you wrote and tried as two IF functions and seems to work. Thanks again for quick reply

[ssanfu]

You can try

Dim  txtUserID as String

'look up a value
txtUserID = DLookup("strUserRole", "tblUserLogin", "[strUserID]='" & Forms![_frmLoginVerify]!txtLoginName & "'")


If txtUserID  = "Consultant" Or txtUserID  = "PSR_A" Then

     ' other statements

End If

You really have a form named "_frmLoginVerify" (underscore as the first character) ????

[jdashm]

Thanks for the response. It looks like that worked.
And yes I put an underscore (_) in front of the form name so that it would display at the top of the forms object list.

[ssanfu]

Glad you got it sorted out.

Didn't think Access would allow an underscore as the first character (but I never tried it ). Good to know.