Add a Close Form command button to your Access form

Once you disable the Close button on a Microsoft Access form,
you might be perplexed as to how users can close the form when they are done.
You can simply use the command wizard to add a button to the form that, when
clicked, will allow users to exit the form.

First, you need to open the form in Design View, and make
sure the Control Wizard button in the toolbox is selected. Then, follow these
steps:

1. Click
   the Command Button tool, and then click where you want the button to
   appear in your form.
2. Select
   the Form Operations category and then click Close Form under Actions.
3. Select
   the default text or type your own, and click Next.
4. Enter
   a name for the command, such as CloseForm
   button, and then click Finish.

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.