Access Search and populate

[jgolba99]

I have an access database that is being filled in with different client names. I also have a form that when filled in does a mail merge to word so that letters can be sent out to people with their personal information. I want to know how to search in the database and when I click on the appropriate client it will put the information into the form. I have Office 2010 products and am using windows 7. Let me know if you need more information and I can supply it. The other option is that I create a seperate search form and when I search for something it will pull up multiple results in a grid and then from there I can click on the client that I want and send it to the 1st form.

[June7]

Review tutorials at http://datapigtechnologies.com/AccessMain.htm especially the ones about Filter and Search form in section AccessForms:TipsAndTechniques