I am new at ALL of this. My question; what is wrong with this code (if anything) or what process can I use to determine the root of my error
MS VB Run-time error '3075':
Syntax error (missing operator) in query expression 'tbl2EmployeesTypes1= AND FormName='frmLogin".
This is the code:
Private Sub Form_Load()
If DLookup("HasAccess", "mainForm", "tbl2EmployeeTypes1=" & TempVars("EmployeeTypes1")
& " AND FormName='" & Me.Name & "'") = False Then
MsgBox "You do not have the IMHS Credentials to advance. Your request will terminate!"
DoCmd.Close acForm, Me.Name
Thanks for all the help
Lawrence aka Bishop