SQL Query Syntax

L

Little Penny

I cant figure this out if I use Like in the below statement it works
grear no problem.



GCriteria = Forms![frmSearchByJob]![cboSearchField].Value & " LIKE '*"
& Forms![frmSearchByJob]![txtSearchString] & "*'"


If use use the = sign i get an error in the statement I get no
records.

GCriteria = Forms![frmSearchByJob]![cboSearchField] =
Forms![frmSearchByJob]![txtSearchString]


Is there something wrong with the sytax?


Any help would be appreciated
 
Top