Using a form to find a record

[Mikewl]

I have a client with almost 200 Smith's in his database. Using FIND takes him forever as it moves to the next, and next and next, etc.
I created a form (datasheet view) based off of a query where he enters the last name and it shows last name, first name (sorted ascending), and client #. This way he can scroll through until he finds the right Smith (jones, etc.)

Here's where I'm having trouble: I would like him to be able to just click or double click on the client and have him go back to the Main_Form with that clients record on the form.
Any ideas on how to update the Main_Form with whatever record he chooses from the query based form??

 

[kellan4459]

I have a sample similar to this I will e-mail you. I started with a form with a combo box to find the person I want. When you hit the open button it then pulls up a list of items related to that person(based on a query). When you select the recordset you want to edit it then opens that record in a new form window(based off of a query just like the first one with a different criteria). If you would like I will send it to you.

 

[Mikewl]

Thanks. I would appreciate it.

(Your message reminded me I needed to update my e-mail address. Now it's current.)

Thanks a lot!!

 

[kellan4459]

sent file