Run code on open

[snipe]

Hey guys,



I am trying to have a good amount of code run when Access is opened.

I created an AutoExec macro with a RunCode of "RunMontageAuto()"

I have a module called AutoMontage with one public sub in it called RunMontageAuto().

I get the error stating that Access can't find RunMontageAuto.

What's the best way to do this?

[June7]

I thought macros could only call functions. But I don't use macros so not sure.

Could set a form to open by default and call the sub from the form Open event.

[snipe]

Ah good idea.

[snipe]

Worked great! Thank's again!