Trying to use an IF statement with an AND - is this possible?

[shabbaranks]

Hey guys,



Im trying to create a form which holds a list of departments. The user selects a department and if they are a member of that department and in a managers group then run a query which selects users from a table excluding themselves.

I have added the groups, I have added a column to the users table which holds thier group membership and now I am starting (trying to code). But Im not entierly sure how to go about it. I would need to use an IF sUser and groupID = me.departmentcombo.columnx

column x matching the groupid of sUser?

Thanks

[Robeen]

I just ran this If statement in Access 2010. I think it will work in any version, though.

Me.Order.SetFocus
strOrder = Me.Order.Text
 
Me.Customer_Name.SetFocus
strCustomer = Me.Customer_Name.Text 
 
If strOrder = "112" And strCustomer = "Johnny" Then
MsgBox "Johnny - 112!!"
End If

I got the messagebox to pop up when I hit the row of data on the Form in which the Order Number was 112 and the Customer Name was Johnny.

So - Yes - it IS possible.

I hope this answers your question?