Hi, I've seen various search solutions on other access sites. Most involve some truly mindbending VBA code etc. I'm amazed at the simple, elegent search form in this tip. Thank you very much indeed. Just a couple of quick questions.
How can I get the search results to show as a form (each record on a page)instead of showing all results in table data sheet view ?
Apologies if i'm missing something pretty obvious here !
What is the ETA for the search form seminar ?
Many thanks.

---

Reply from Richard Rost:

The SEARCH FORM TIP VIDEO shows you how to create a query based on the search criteria you specify. You can now use that query to do anything you want, including building a form or report. Just make a form using that query as the recordsource. Now from the search form button, just open your new form instead of the query directly (Docmd.Openform). Easy enough?

The Search Form Seminar will have about 20 different ways to perform searches starting with the most basic (using the Search button) to very complex (some crazy dynamic, mindbending VBA code like you mentioned) and everything in between.

ETA? Not sure. I really need to finish the Excel Expert classes and get some BEGINNER Access 2010 lessons out. I'm losing a lot of new users because they want intro Access 2010 classes, and my Access 2003 lessons just don't cut it (new interface and all).