Search Function in a form

[PJ]

I have multiple unbound combo boxes in a form and the row source is base off
of a table. When I select data from one of the combo boxes I click on a
command button to print a report based of the data I selected. I want to be
able to select data from multiple combo boxes and have a report print instead
of having one report for each combo box.
Example:
Select a “Issuer†from a combo box
Select a “ Segment†from a different combo box
Print a report from that criteria instead of two separate reports(one for
Issuer and one for Segment)
Also some of the combo boxes may not have any criteria in them.

Any ideas on how would I do that?

Thanks in advance

 

[Dale Fye]

Check out Allen Browne's (www.allenbrowne.com) web site. He has some great
examples. In your case, check out http://www.allenbrowne.com/ser-62.html

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.