Combine reports

[bishop0071]

What I want to do is create 2 drop down boxes on my form from tblClients. Pull information from tblWO_Dates that contains 5 different fields and have a report generated from that. For example:



Report

Client 1 Field 1 Field 2 Field 3 Field 4 Field 5

Client 2 Field 1 Field 2 Field 3 Field 4 Field 5

Any help is appreciated.

[June7]

You want to apply filter criteria to two fields of report? For one method, review http://datapigtechnologies.com/flash...mtoreport.html

[bishop0071]

Yeah I looked at that but won't work. Criteria for one field which is name

[bishop0071]

Or can I have 2 of those combo boxes and have the report run with those selected?

[June7]

Then need VBA code to build the filter criteria.
Review
http://allenbrowne.com/ser-62.html
http://allenbrowne.com/ser-50.html