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

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.