Request for Help! Filtering a Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top