use different forms for startup depending on external criteria (1 Viewer)

[Happy YN]

I have one db with various forms. I would like to have different forms open at startup depending on external criteria. In short can I run any code before any form is opened which would look like this
dim Startup as string
startup= source.........
docmd.openform startup

Should I put this code in an invisible form which will run it on load and then close itself or can I run it before any frm is opened
Thanks

 

[WayneRyan]

Happy,

You can have a startup form that runs every time you open the database.
In its OnOpen event, you can put whatever logic you need to control
which form(s) open next.

Need more info about what these external things are though.

Wayne

 

[Happy YN]

Thanks!
I was planning on getting information from another file