Re: Request for Help! Filtering a Report
- From: "Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxx>
- Date: Tue, 14 Mar 2006 20:56:05 -0600
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
--
Duane Hookom
MS Access MVP
--
"Landywednak" <Landywednak@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0573FA5C-CFED-412A-A907-B7F3EF5964A1@xxxxxxxxxxxxxxxx
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?
.
- Prev by Date: Sizing Fields and Report Width
- Next by Date: Re: My report puts feb 2006 before January 2006, and December 05
- Previous by thread: Sizing Fields and Report Width
- Next by thread: Re: My report puts feb 2006 before January 2006, and December 05
- Index(es):
Relevant Pages
|
