Switch from form to report as soon as database loads?

[Adamantium42]

Hello.

I'm having a frustrating problem.. I have VBA code that switches a form to a report that works with buttons but refuses to work when first loading up the database.

Ideally I want the database to open , with a control form set as the default load form, and then this immediately loads a report, which it does, but it doesn't ever switch to it?

I use as standard: DoCmd.OpenReport "rpt_here", acViewPreview, , , acWindowNormal

and now I've tried
Application.DoCmd.SelectObject acReport, "rpt_Embroidery_Screen"

Which will both run and work fine using buttons but not on initial database/form load.

Has anyone else encountered this? Using Access 2010.

Thanks.

 

[EternalMyrtle]

So, you have the main form (switchboard) as the form and in the OnLoad event for the form you put in the code to open the report, correct?

Is the report set to pop up and modal in the properties > other tab?