Quick Fix

[jayhamz]

I keep getting access denied even though i want to deny just 2 and 3 please help

table (Accesslevel)
1 Manager
2 ..........

3 .........

Private Sub Form_Open(Cancel As Integer)
If DLookup("AccID", "tblSecurity", "[SecID]=" & Forms!frmLogin!CoUserName) >= 1 Then

    MsgBox "ACCESS DENIED", vbOKOnly
    DoCmd.Close acForm, "FrmEmployeePage"

End If
End Sub

 

[mattkorguk]

Change to just >1 and not >=1?!