Can I have Access open a Report on open 1

[chrisgeek]

I have a form/query/report all together and I'm wondering if I can have Access open this report automatically on open. I can't seem to figure out the VBA that will do this.

Thanks in advance,

Chris

 

[genomon]

Create a macro called autoexec or autoexec.bat (can't remeber which) that does a Do.Cmd OpenReport action for the report you want. If it doesn't pop up, try calling the macro as the startup object under the tools dropdown menu.

Ever notice how fast Windows runs? Me neither.

 

[genomon]

AHA - found it!

http://www.databasedev.co.uk/autoexec-macro.html

Ever notice how fast Windows runs? Me neither.

 

[chrisgeek]

That's it exactly. Thanks!