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!

Multiple reports from one form?

Status
Not open for further replies.

ashows

MIS
May 10, 2002
25
US
My Access XP database contains several reports. For each report the user needs to be prompted to enter a beginning and ending date which are used to select records from the database. I've created a form and query which work w/ a single report. Is there a way to use this same form to allow users to enter the dates for all of the reports? Each report uses a different query.

Thanks in advance.
 
If the date range is the same for each report and you are using a command control, why don't you just open the reports one after the other in the code associated with the command control?

Alternatively, you cou;ld but a series of command buttons on the form, one for each report. This way they could heve different date ranges, if necessary.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top