Stuck on DLookup

[ozzroo]

I have a login form which users DLookup to get the password and username from a table called tblStaff

I also have a field in that table called "SecurityLevel"

If the users log in correctly this will go to the main menu

I want to be able to make buttons visible or not visible depending on user security level

I cant get my DLookup function to work on the main menu so it users the correct security level. I can get the currentuser to the main menu but not the security level.

My code is

If DLookup("[SecurityLevel]", "tblStaff", "[StaffID]=[Forms]![frmMainMenu]![CurrentUser]") <> "Administrator" Then
....

Any help please?

 

[Remou]

Try a small change:
[tt]If DLookup("[SecurityLevel]", "tblStaff", "[StaffID]='" &[Forms]![frmMainMenu]![CurrentUser] & "'") <> "Administrator" Then[/tt]
If StaffID is text or
[tt]If DLookup("[SecurityLevel]", "tblStaff", "[StaffID]=" & [Forms]![frmMainMenu]![CurrentUser]) <> "Administrator" Then[/tt]
If it is numeric.

 

[ozzroo]

The CurrentUser field on the mainmenu is sourced from the username combobox on the login form.

The code you gave me above doesnt come up with any errors. but whatever user I login with it always comes up with a true result even if the user is not an administrator. if they are a normal user it still works.

If DLookup("[SecurityLevel]", "tblStaff", "[StaffID]=" & [Forms]![frmMainMenu]![CurrentUSer]) <> "Administrator" Then
MsgBox "You are an Administrator"
Else
MsgBox "You are not an Administrator"
End If

I just used message boxes as a test. Like i said it comes up with "You are an Administrator" even if they are not.

Do I have to add statements for the other security levels?

The security level is not a text field, its a number field in the staff table.