I've got some code I'm running when my database starts up via RunCode in my AutoExec macro. The code simply opens one form. The problem is that my form opens and then closes immediately afterwards (just sort of flashes on the screen).

I think I've got the macro set up correctly. I've got the function in its own module, here's the code to my open form function:

Public Function openForm()
Set msubjects = New Form_frmSubjects
msubjects.Visible = True
End Function

This is my first go at using macros, so its entirely possible i've overlooked something. Any suggestions?

You don't need to use a macro in this case, just use the StartUp options on the Menu