On database open

[stricknyn]

THis sounds simple enough, but I can't figure it out for the life of me. I have a function and a macro in Access which does exactly what it is supposed to do. What I want to do is run the function and macro as soon as the database opens. I don't want to put it in a form load because I want it to check for some things as soon as the database opens. Anyone have any ideas? THanks

James

[alex_read]

Sounds it, but isn't - took ages for me to find when I needed this :rolleyes: !

Anyway, goto the macros section of access, create a new macro & set the top action to RUNCODE adding the name of your custom function procedure to the bottom of the screen (the "function name" parameter box).

This is the only way access will run a code procedure upon startup. This macro has to be named AutoExec.