Carry out an action when my database first opens

You can use a special macro named AutoExec to carry out an action or series of actions when your database first opens. When you open a database, Microsoft Access looks for a macro with this name and, if it finds one, runs it automatically.

1. Create a macro containing the actions you want to run when you open the database.

   How?

2. Save the macro with the name AutoExec.

The next time you open the database, Access runs this macro automatically.

Notes

• If you don't want to run the AutoExec macro when you open the database, hold down the SHIFT key when the database opens.
  
  
• You can also control how a database or application starts by setting options in the Startup dialog box (Tools menu). For more information, click .