PDA

View Full Version : Why am I getting a runtime 3075 missing operator error in the following statement


atchou69
Aug 5, 2011, 07:38 AM
strSQLA = "SELECT * FROM tblAgreements WHERE tblAgreements.[ID] = LIKE " & "*" & [Forms]![frmSearch]![txtFind].[Value] & "*"*" ;"

This code is inserted in as VBA in Microsoft access 2010, basically look in the table agreements within ID, for the user's input, say 550 entered in text box.
Can you assist?