opening a detailed report from a summary report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Microsoft Office Access 2003 what could I do to open a detailed report from a
summary report by using a command button? or other user interaction since the
user may not want to open a detail report always, but if needed.
 
Don said:
Microsoft Office Access 2003 what could I do to open a detailed report from a
summary report by using a command button? or other user interaction since the
user may not want to open a detail report always, but if needed.
Click to expand...


Reports are static displays (like a piece of paper) so you
can not place clickable controls on a report.

It's easy enough to place another button on a form that will
open the detailed report though.
 
You might be able to use a check box on a form that hides the detail
section. Or just place code in the On Open event of the report like:

Private Sub Report_Open(Cancel As Integer)
Me.Detail.Visible = _
MsgBox("Do you want to see the details", _
vbYesNo + vbQuestion, "See Details") = vbYes
End Sub
 
Back
Top