Is it possible to create a search function on a button that searches through records?

[wedd]

I tried creating a search button using the wizard for a customer database I created, however, the search function for the customers – sometimes it doesn’t work. Also I need to be able to search all the fields. So if I search “Berlin” and there are multiple records with “Berlin” – I would like to display all possible results containg the word "Berlin". Can this be done? If so, how can this be developed?

Thanks for your contributions:friends:

[hansup]

Access includes a feature called "search by form" which supports flexible searching values in your form. In Access 2003, it can be found from the main menu: Records -> Filter -> Filter By Form.

If that doesn't suit your purpose, consider Allen Browne's Search criteria (http://allenbrowne.com/ser-62.html) form. He provides a downloadable sample database so you can see it in action.