"Search" to retrieve specific form records 1

[RachieD]

Hi - I want to create a "search" on a new form / switchboard to bring up only the form records relating to a specific client without using the filter option.

The form I want users to retrieve is called frmDealDetails and the information I want them to search on is called [client]. frmDealDetails contains a subform and I want both the mainform and subform to be retrieved so they can be edited by the user.

I am a bit new to all of this so I would really appreciate examples using the details I have given so I can cut-and-paste!!! Any help you can give with this will be really appreciated!!

Thanks
RachieD

 

[hymn]

Have a look at the threads below

Thread702-534577
Thread702-563930

Hope this helps
Hymn