ms access search help

[newuser]

Hi there hoping that someone can help. I have ended up having to build an access database with very very limited knowledge.... I have pulled together several tables which are all linked to the one main record. I have forms for inputting information and some queries that run across multi tables.

The Issue that i have at the moment with this database is building a search function that allows users to search on one or more data fields. I have a form with unbound fields and a query that has the data that I would like to present to the user. At the moment I am adding a command button to the form with the unbound fields with the following:

stLinkCriteria = "[Ref_number] like " * " & Me![Text0] and [Amount] like " * " & Me![Text2]"
DoCmd.OpenForm stDocName, , , stLinkCriteria

In my head I think this means that the user can use either the ref number or amount to search on and if the field is blank then it will not impact the search...

Could anyone let me know if my thinking is correct?

Thanks

 

[HiTechCoach]

You're close. You must wrap tet string with Quotes.

Try:

stLinkCriteria = "[Ref_number] like ""*" & Me![Text0] & """  and [Amount] like ""*" & Me![Text2] & """"

Boyd Trimmell, Microsoft MVP - Access Expert
aka HiTechCoach