Pardon the techie entry, but I wanted to give kudos to Allen Browne. He is a Microsoft Most Valuable Professional awarded in the Access expertise.
I volunteered to design a database for TWC2, and have been dredging my brain for the skills I used to have with Access. A lot has changed since I last created a full-fledged database.
I found myself puzzling over how to create a Search field for a form and searched on the internet for examples. Stumbled onto Allen’s page that has an easily installable code module that will enable your form to have “Find as you type” functionality.
If you’re looking for Microsoft Access help, his tips page is a great place to start.