DoCmd.Openform criteria help needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am getting an error message (Access 97) :

syntax error (missing operator) in query expression '[EmployeeID] Like *123*'

The code is:

DoCmd.OpenForm stDocName, , , (DLookup("[EmployeeID]", __
"tblEmployees", "[EmployeeID] Like" & "*" & Me.Searchtext & "*" ))

Any help would be appreciated.

Cheers
 
Try

DoCmd.OpenForm stDocName, , , (DLookup("[EmployeeID]", __
"tblEmployees", "[EmployeeID] Like '" & "*" & Me.Searchtext
& "*'" ))

Hope This Helps
Gerlad Stanley MCSD
 
Many Thanks!!!! I've been looking for a solution to do simple searches and
this has solved it.

Cheers


Gerald Stanley said:
Try

DoCmd.OpenForm stDocName, , , (DLookup("[EmployeeID]", __
"tblEmployees", "[EmployeeID] Like '" & "*" & Me.Searchtext
& "*'" ))

Hope This Helps
Gerlad Stanley MCSD
-----Original Message-----
I am getting an error message (Access 97) :

syntax error (missing operator) in query expression '[EmployeeID] Like *123*'

The code is:

DoCmd.OpenForm stDocName, , , (DLookup("[EmployeeID]", __
"tblEmployees", "[EmployeeID] Like" & "*" & Me.Searchtext & "*" ))

Any help would be appreciated.

Cheers
.
Click to expand...
Click to expand...
 
Back
Top