Microsoft Office Tutorials and References
In Depth Information
Setting Up Your Own Main-Menu Form
Setting Up Your Own Main-Menu Form
You can make your own main-menu form by creating an unbound form (a
form with no record source) with command buttons that run macros (see
Figure 2-8). For some commands, you can use the Command Button Wizard
to create an embedded macro instead of writing the macro yourself.
Figure 2-8:
A completed
main menu.
Each button
runs a
Here’s the sequence:
1. Create the main-menu form.
2. Create a macro to contain submacros run by buttons on the
mainmenu form.
3. Create a macro named AutoExec that contains an OpenForm action to
open your main-menu form so that Access displays the form
automatically when you open the database.
4. Create each command button that you want to use on the main-menu
5. For a command button that does something that the Command Button
Wizard doesn’t offer, write a submacro for the command button to run,
and set the button’s On Click event property to run the submacro.
Creating a form that appears
when the database opens
To create an unbound form that appears when you open the database,
follow these steps:
1. Create a new form by clicking the Form Design button in the Forms
group on the Create tab of the Ribbon.
Access opens a form in Design view.
2. Save the blank form by clicking the Save button on the Quick Access
toolbar or by pressing Ctrl+S.
Search JabSto ::

Custom Search