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

  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.