Auto Run a Macro when the table is loaded

[SarojaKannan]

Hi all,

I have written a macro in MS Access in the same database where i have the tables, i want to auto run the macro when i open the database, Please help me how to do this

[cori25]

Hello,

In order to have either a query, macro, module run on open of access all you need to do is create a new macro. Select the RunMacro that you would like to have run on open, when you save this macro you must name it "autoexec". You must spell it exactly like I have done here. Then when you open the database, your macro will run.

Hope this helps, if not let me know because there are other methods although I prefer this one.

Thanks