Newbie Trying to Follow "Dynamically search multiple fields" thread (1 Viewer)

[MJHirsch]

I am a total Access newbie and am trying to follow John's thread, "Dynamically search multiple fields" using my own customer data.

I'd like to add in additional searches as what he has will let you do one search but I'd like to, in his example, search on vintage and state, or the like. I assume Id need two multi-searches for this.


Right now the data is in excel so I have a completely blank page to fill.


Thank you to anyone who can put me on the right track for this project.

 

[Minddumps]

To search mult columns in a query, just ensure the

Like "*" & [Forms]![frmSearch]![txtSearch2] & "*"

is in each column (on a new OR field that no other column has info on).

 

[namliam]

I am a total Access newbie and am trying to follow John's thread, "Dynamically search multiple fields" using my own customer data.

Will be helpfull to have alink to the thread you are following and perhaps what you have tried/failed or run into that you need help with.