Hi

I need to create a form whereby users can search for information from multiple forms, and then open a particular record within that form. I currently have a 'Main Menu' with buttons that open forms, but they always open on the first record and the only way to find the one you're looking for is by going through each one. So my questions:

1) How do I create a search button on the main menu that will search within each form and open that record/s?

2) How do I create a search that will search for non-exact matches? For example - search for 'Grange' and it will open '2 Grange Place' and 'Grange House'.

Thanks.

---

Reply from Alex Hedley:

Check out the Search Seminar. It's a treasure trove of searching techniques.