report after 'between' parameter in query

[Chris C.]

Hello,

I have a form where the user can see a list of articles between number x and
number y, based on a query with "between ... and ... in the criteria). How
do I get the result of this query on a report without having to fill in
number x and y again?

Thanks for your suggestions.

Chris

 

[Duane Hookom]

Where/how does the form get the criteria? If you are using a parameter
query, I suggest that you replace the parameters with references to controls
on a form.

 

[Chris C.]

Duane,
I'm in fact using a parameter query (one pop-up fill in for number x + one
for number y). What kind of controls do you mean (combo box and so??) and
how do I make the references on a form?

Chris

 

[Duane Hookom]

You create a new (or use an existing) form. Assuming "frmX". Add text boxes
or combo boxes that will allow the user to enter or select the values you
want to use in your criteria. Assuming "cboAccountNumber" and
"txtStartDate". Your criteria can then use:
Forms!frmX!cboAccountNumber
and
Forms!frmX!txtEndDate
The form must be open and values entered.

 

[Chris C.]

Thanks Duane. That's what I was looking for.