I have a database that I would like to be able to print only customers from
a specific zip code. I would like to create a form to do the search by
asking for the zip code. A combo box would work fine. Creating the form is
not the problem. #1...I am having problems filtering the combo box so it
does not show all 1300 records. I don't need duplicate zip codes in the
combobox. #2...I can't figure out how to create the button to print the
report with only the data selected in the combo box.

Any help would be greatly appreciated.
Thanks
Mike

"mmi" <mikehigh3 (AT) mchsi (DOT) com> wrote

If I am following you correctly ...

If you select a value in a combo box you can then use this value to
filter the data that goes to the report.

1. Make a query for the report
2. Set the filter criteria as: [forms]![yourform]![yourcombobox]
3. Make the report using this form as the data source
4. Make a command button to open the report

Thanks for the help!! You have put me on the right track.

Thanks again,
Mike
"Mark Thomas" <m.thomas57 (AT) ntlworld (DOT) com> wrote

"mmi" <mikehigh3 (AT) mchsi (DOT) com> wrote

Let me know if it works.

I have, however, spotted an error in what I wrote above.
It should be:

3. Make the report using this query as the data source
and
2. Set the filter in the query as ... etc

I did get it working perfectly! Thanks!

Mike
"Mark Thomas" <mthomas (AT) beacon (DOT) surrey.sch.uk> wrote