How can I use the search macro in a MainForm to also search a subf

[jfrieders]

Hello,

I currently have a database main form for basic customer service info, name
and address. I have a subform containing specifics for individual return
requests (multiple return authorizations) for that customer. Each new RA is
a new record in the subform relating to the same customer.

When I perform a search, it is sometimes easier to search for the RA number
(located in the subform) than the customer's name in the main form (which I
can do now with a search macro in the main form). Is there a way to modify
the standard search macro in the mainfrom to also include the RA field in the
subform?

Thank you.

Jason

 

[bhicks11 via AccessMonster.com]

The syntax for referring to a subform is:

Forms![Orders]![Orders Subform].Form

Bonnie

<a href="http://www.dataplus-svc.com">Data Entry - Document Scanning -
Database Programming</a>