creating report from 2 combo box

[bishop0071]

I need to create a report from 2 combo box. The information being generated will be the same. So I have a firstname, lastname, field 3, field, 4, etc. I want to be able to create a report with 2 people with those fields generated

Example:


Combo box to choose 2 names: Name 1 and Name 2
Click Run Report
Have the info from those names chosen under 1 report

[June7]

Not clear what you are doing.

You have 2 comboboxes, select a name in each combobox? Review http://datapigtechnologies.com/flash...mtoreport.html

Or

There is one combobox and select 2 names?

[bishop0071]

What I would like to do is create 2 combo boxes that allows me to choose any 2 names. Then be able to run a report from that. Just don't know how to set it up.

[June7]

These names would be criteria for the same field? Use VBA code to construct filter criteria.

Review: http://allenbrowne.com/ser-62.html
open link in that article "view the code in a separate window".