Command Button on Report

R

Ray Hogan

Hi,
Please advise if it is possible to place Command Button on a Report to open
another report.
Thanking you in anticipation.
regards.
Rayh
 
F

fredg

Hi,
Please advise if it is possible to place Command Button on a Report to open
another report.
Thanking you in anticipation.
regards.
Rayh
Click to expand...

No.
Reports are passive views of data, and a command button would not do
anything.

What you can do is code the Report's Close event:
If MsgBox("Do you wish to open ReportB?",vbYesNo) = vbYes Then
DoCmd.OpenReport "ReportB", acViewPreview
End If
 
Top