Find Field

[Karyn]

How do I coordinate my find field in my main form so when I click on Smith, Kathy her form comes up. The way my form is currently setup,if I choose Smith, Kathy and I have more that one "Smith" in my database, example (Smith, Jane; Smith, Tom) Jane will display first.

Any help in advance is greatly appreciated.

 

[Jack Cowley]

You could use a combo box on your form to locate the proper record. Just create a combo box using the Wizard and select the third item on the the first page, "Find a record...". Then just follow the rest of the instructions....