Ask for Criteria.

[Andy]

Hi;

When I was new to Access I use to create multiple queries with different
criteria for multiple reports:
qryItemsOnOrder Criteria >0 rptItemsOnOrder
qryItemsInStock Criteria >0 rptItemsInStock

Learned that can use strCriteria and only one qry and only one rpt
Dim strCriteria As String
strCriteria = "[ItemsOnOrder] > 0"
DoCmd.OpenReport "rptItems", acPreview, , strCriteria
Or
Dim strCriteria As String
strCriteria = "[ItemsInStock] > 0"
DoCmd.OpenReport "rptItems", acPreview, , strCriteria

What I need to learn is how to display a dialog box that asks the user for
the criteria.

What code do I need to add to display a dialog box that asks the user for
the strcriteria and then to use that criteria for the report.
Example:
Dialog box 1: "Enter Begining Date."
Dialob box 2: "Enter Ending Date."
And the report will display only the information in that date range.

Would someone be so kind to steer me in the right direction.

Thank You.

Andy

 

[Duane Hookom]

I would rather have a single form per report so the user isn't prompted
multiple times for various values. Martin Green has several examples at his
site http://www.fontstuff.com/access/index.htm.