Query records within form

[brettthenry]

I am new to OO and am creating my first database for event registration purposes. I have written a simple form for data input and it successfully inputs records into the table. Then, I have created a second form that contains a subform. My intention is to be able to enter a piece of information into this second form and have the subform below pull up all records associated with it.

For instance, if "Joe Smith" from "XYZ" company were to come to the registration counter, I want to be able to type in either his name, a part of his name, or the company name and have the subform populate with everyone else from that company so that I can check them all in.

I have the forms working and the subform recognizing the relationships etc. I cannot figure out the query feature though. I'm hoping someone can help me write this macro and look up the records. Any help is greatly appreciated- I don't really know what I'm doing.

[dacm]

Perhaps these examples will help:
[Example] Filter/Search with Forms (leveraging SubForms)
[Example] Searching in a form with macros
_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Migrating 'Embedded databases'