Syntax Error - missing operator

[mosh]

Hi All,

I have a form that uses network ID to identify whether a record has been created by the user on the database, but i seem to get the following error on this code:

Syntax Error (missing operator in query expression) 'Staff_id ='.

Private Sub Form_Current()
Me.employee_lan.Value = DLookup("employee_lan", "tblStaff", "Staff_id= " & Me.staff_id)Dim Emp, Lan As String
Lan = GetWorkstationLan
Emp = DLookup("[Employee_Name]", "[tblStaff]", "[Employee_Lan] = '" & Lan & "'")
If Me.employee_lan.Value = Emp Or Me.employee_lan = Lan Or IsNull(Me.employee_lan) Then
EnableEverything
Me.employee_lan = Emp
Else:
DisableEverything
End If
End Sub

Any help would be great,

thanks,
________
LIVE SEX

 

[mosh]

error occurs when i go to the end of the recordset.
________
Marijuana bubbler

 

[mosh]

can anyone help?
________
TOP RATED VAPORIZERS