Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MsgBox to Enter Criteria for Report

Status
Not open for further replies.

dkmidi

Technical User
Mar 13, 2002
47
CA
Hi Everyone,
I've seen this done with another persons reports where a msgbox pops up asking which month's data they would like to see. How can I do this too?

Is it done using the original query that the report pulls the data from?

Thanks!

Derek
 
Hi Derek!

Yes it is. In the criteria line of the query put:

= [Which month do you want data for?]

and the parameter box will pop up when the report runs the query. Of course, you must include a field which has the month in text format.

hth
Jeff Bridgham
bridgham@purdue.edu
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top