Same report - Summary or Detail

[MelissaBerrett]

I have the same query for two reports. The reports are the same, except one shows detail and the other is a summary . Instead of have two options on my switchboards, can I limit it to one, and let the user choose to see the report in either summary or detail? Thanks!

 

[SgtJarrow]

Can think of a couple of ways...but here is one that is pretty easy....

In the OnClick property of the button, put the following

Dim strMsg As String
strMsg = MsgBox("Do you want to see the summary? (Clicking no will display the details.), vbYesNo, "Display Summary?&quot
If strMsg = vbYes Then
' Put your summary report stuff here
Else
' Put your detail stuff here
End If

You could also create your own small pop-up form asking which to view....send me an email if you like and I can put together an example for you... Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need!

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com

 

[MelissaBerrett]

Won't this effect all the reports? (I have 3 switchboards and 6 reports) Some of the reports do not have a summary. Would a pop-up be better - how does that work? Thanks!

 

[SgtJarrow]

You would set this up on each of the buttons you wanted it for...If you didn't want any summary/details options for a particular report, don't use the code....

Send an email to the address in my sig bloack and I will forward you a database that has both ways set up for you to see..... Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need!

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com