Populate/Filter Subform based on Mainform search criteria?

[hjeff71]

How do you populate/filter a subform based on search criteria in the main form?

Main form has a “search field” with a command btn.

The “search field” will find the search criteria in any fields, and populate/filter the subform with all the records it finds, no matter what field it found it in.

(attached is a “Blank” db with an example of how it would look like.)

 

[Uncle Gizmo]

Sounds very interesting what you're trying to do, however it's not normally done that way, so I would be very surprised if anyone has done it.

My guess is you will need to write a query for each field in your table, use the search box as criteria for each query, and then I think you would need to write a union query to link "each" of those queries together.

The queries based on each field in your table; should be easily constructed with the query designer grid, however you have to write union queries manually.