View Single Post
  #4 (permalink)  
Old January 30th, 2006, 08:54 AM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Well, there are a few ways to do this.

If both forms are open and Form 2 has a print report button, you can shift focus to Form 2, activate its print button, shift focus back to Form 1.

Me.Form2.SetFocus
cmdPrintButton_Click
Me.Form1.SetFocus

I'm using fake control names Form1, Form2 and cmdPrintButton. Use your real names.

If Form 2 is not open but its report is based on the same query as Form 2, you don't even have to open Form 2. Just open the report it's based on from From 1's print report button.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote