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!

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

# reports with one click

Status
Not open for further replies.
dixxy

dixxy

Technical User
Mar 4, 2003
220
CA
Hello,

Is there a way to open 3 different reports with juste one button click?

Thanks,

Sylvain
 
Sort by date Sort by votes
In the On Click event of your command button, put code like this:
Code: 
DoCmd.OpenReport "report1", acViewPreview
DoCmd.OpenReport "report2", acViewPreview
DoCmd.OpenReport "report3", acViewPreview
Just take off the "acViewPreview" if you want them to print directly....
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Teri Bridges
  • Locked
  • Question
Reports Combobox-List box
Replies
1
Views
476
dhookom
dhookom
breezett93
  • Locked
  • Question
What should be multiple reports is becoming one report with multiple pages 1
Replies
13
Views
462
dhookom
dhookom
RonMcIntire
  • Locked
  • Question
Page Numbering a report with vba
Replies
6
Views
470
dhookom
dhookom
Kennelbloke
  • Locked
  • Question
Problems with image on report 1
Replies
8
Views
355
dhookom
dhookom
ptrifile
  • Locked
  • Question
Sum with multiple criteria
Replies
2
Views
355
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top