Request for Help! Filtering a Report

L

Landywednak

I have a quotation table, in which, records are entered via a Form interface
and I have a Report for printed output. Using a parameter query to filter
which, quote(report) is to be printed is sort of fine EG: [Enter Date] ,
[Enter Name]. But I would like to present this to the end user in some form
of choice list, combo, option...whatever...

So if the end user whishes to reprint a quote for example they could maybe
view a list of quote for the past 3 months (say Date, Customer Name, Amount)
choose it (click) and ONLY the coresonding report opens in preview mode ready
to print.

Can anybody help me with this please?
 
D

Duane Hookom

You can create an unbound form with combo boxes, list boxes, text boxes, etc
that allow users to make easy selections. Then either build a "where" clause
to use in the DoCmd.OpenReport method or set the criteria in the report's
record source like:

Forms!frmYourForm!cboQuoteID
 
Top