Reports

  • Thread starter Thread starter anonymous
  • Start date Start date
A

anonymous

I am not a programer so could you be detailed in your
explantation.Thanks. An icon on the switchboard references
a report that displays beneath the switchboard. There is
another icon for displaying a form which does display on
top of the switchboard. How can we get the report to
display on top of the switchboard like the form displays?
 
If I understand what you're asking, this is what you need to do

1) Open your switchboard in design vie
2) If the properties box is not displayed, right click on the icon that you want to display the report, then select "Properties
3) Click on the tab that says "Events
4) On the line that says "On Click", select the drop-down arrow and choose "[Event Procedure]
5) Click on the ellipisis "..." button next to the drop down arrow. That should take you to the VBA screen with the cursor between two lines of code like the ones belo

Private Sub CommandXYZ_Click(

End Su

where "CommandXYZ" is the name of the button on your for

6) Type the following right where the cursor is flashing: DoCmd.OpenReport "MY_REPORT", acViewPrevie

where "MY_REPORT" is the name of the report you want to displa

The end result would look like this

Private Sub CommandXYZ_Click(

DoCmd.OpenReport "MY_REPORT", acViewPrevie

End Su
 
Sorry for the loss of detail. The report runs without any
problems. It is the window of the report, when run is
located behind the switchboard window. How can you get it
to display in front of the switchboard when you select the
switchboard icon for that report?
-----Original Message-----
If I understand what you're asking, this is what you need to do.

1) Open your switchboard in design view
2) If the properties box is not displayed, right click on
Click to expand...
the icon that you want to display the report, then
select "Properties"
3) Click on the tab that says "Events"
4) On the line that says "On Click", select the drop-down
Click to expand...
arrow and choose "[Event Procedure]"
5) Click on the ellipisis "..." button next to the drop
Click to expand...
down arrow. That should take you to the VBA screen with
the cursor between two lines of code like the ones below
Private Sub CommandXYZ_Click()


End Sub

where "CommandXYZ" is the name of the button on your form

6) Type the following right where the cursor is flashing:
Click to expand...
DoCmd.OpenReport "MY_REPORT", acViewPreview
 
Back
Top