Software

Add a command button to your Access form without programming

Would you like to add a simple command button to a form, but don't know how to program in VBA? Mary Ann Richardson tells us how Access 2002 and 2003's Command Button wizard lets you add a simple command button to a form without programming.

Would you like to add a simple command button to a form, but don't know how to program in VBA? Access 2002 and 2003's Command Button wizard lets you add a simple command button to a form without programming.

For example, follow these steps to add a button that, when clicked, closes the form:

  1. Open the form in design view.
  2. Click the Command button in the Toolbox. (In Access 2002, make sure the Control Wizards button is activated first.)
  3. Click and drag in the form where you want the button to be located.
  4. Select Form Operations under categories.
  5. Select Close Form under Actions.
  6. Click Next.
  7. Make your selection of either the picture or text.
  8. Click Next.
  9. Enter cmdExit and click Finish.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox