Hi Guys, can I Ask for some advice. I'm fairly new to Access and have an issue regarding a search on a form. I have a combo box to select a table heading and a text box where I can input search criteria. The problem is that my search does not return some records based on a partial text search, for Instance, If I search for "DER" the search returns no records although I know there is a record containing "DERBY". The Macro I am using contains the following:
Where ="[" & [cboSearchHeading] & "] like '" & [txtCriteria] & "*'"
I would appreciate any advice please.
TIA
Dave
Where ="[" & [cboSearchHeading] & "] like '" & [txtCriteria] & "*'"
I would appreciate any advice please.
TIA
Dave