Re: Creating a filtered report

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

Thanks again,
Mike
"Mark Thomas" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "mmi" <[EMAIL PROTECTED]> wrote in message
news:<[EMAIL PROTECTED]>...
> > 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
>
> 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