Building a search function in access

[KCBroncoFan]

It has been a while since I have done much in Access or VB and sadly I seem to have forgotten most of it. I took classes in Access and VB around 5 years ago but wasnt using it until recently.

In theory I thought it would be easy to build something in my database to allow me to search for records by name. I am not finding it so easy due to my time away, I suppose lol.

I am trying to build a search function that will capture user input for what they are searching for then display that record and all things related.

I would appreciate any help in at least getting some basic functionality for this.

Thank you,

Scott

 

[wilpeter]

The active ingredient can be a Select Query, run from a macro built into a command button, if you like. The field name may be long or short and complex or simple, so you may need to play with the search criteria. A known name, for example, "Johnson" (if the field is say LastName) can be prompted for by a Parameter. e.g., [Enter Name to search for]
If more complicated or if spelling is unsure Criteria can contain wildcards. e.g., Like *[Enter Name to search for]* (which will find the typed text within the field values.)