Run report on Open Database (1 Viewer)

[odun]

Hello all,

Please help with this:

On opening my database, I have a switchboard that opens up.

How do also run a report automatically just after the switchboard screen opens. To make the switchboard open when I click on my database, I went to tools..> startup. But I don't know how to run a report automatically after that.

Thanks for your help!

 

[llkhoutx]

Open the report on the Switchboard's OnOpen event, that is,

docmd.openreport "YourReportName"

 

[odun]

Thanks much. I used the AcViewPreview and it worked, but the report stay in the background, I would like to bring it to the front. I checked a few posts, but nothing is working yet. here is my code :


Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.

' Move to the switchboard page that is marked as the default.
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
Me.FilterOn = True
DoCmd.Maximize
DoCmd.OpenReport "Exp", acViewPreview
DoCmd.SelectObject acReport, "Exp"

 

[llkhoutx]

After you open the report in preview mode, set focus to it, e.g.

Reports!Exp.setfocus