Resetting Command Buttons

[Guest]

I've got a send object macro assigned to a command button on a form. After
clicking the command button, it prompts you for an ID#. After you enter the
applicable ID#, then an e-mail is generated with the person's information
filled in. However, after I send or close the e-mail, the command button on
the form stays depressed.

What can I do after the macro is run so that the button resets? I'm not
well versed in code, so please answer using macros/queries. Thanks.

 

[Allen Browne]

If the button stays depressed until you click it again, then it is a toggle
button, not a command button.

1. Open the form in design view.

2. Right-click your button, and choose Properties.

3. Write down these Properties of the button:
Name (on the Other tab of the Properties box)
On Click (on the Event tab)

4. Delete the toggle button.

5. Open the Toolbox (View menu).

6. Click the Command button in the Toolbox.

7. Click on the form where you want the command button.

8. In the Properties box, give the button the same Name, and then the same
On Click property.