How do you create the macro that will open the database with the switchboard?

If you use a macro (This was Originally designed in Access 2.0) you will need to name it AutoExec.

I recommed however to add this to the Database Property. You can access this in the StartUp Options (Access 95 and up) You will be able to place the startup forms name in the db property thus giving you the effect you desire.

Thank you again for this information in addition to the information on opening forms with a new record.