How do you call a module by clicking a button on a form in MS Access?

[StarScream]

How do you call a module by clicking a button on a form in MS Access 2000?

Scenario: Form is used to add a suspense to a master list. Person would then click a button that would automatically email a person to tell them they have a new suspense. The form would have already have some of the information wanted to be included in the email (i.e. subject, email address, etc.)

How do you get a button to do this on a form?
PS - New to using MS Access

Thanks.
PJ

 

[tomschafer]

In design mode right click on the button, goto properties. Then goto the event tab, click on the field for OnClick, at the end of the field click on the button with "...", double click code builder. You should now see the VBA module for the form and should be in the OnClick event for your button. Simply type in the name of your module. You should be good to go now.

 

[Craig0201]

Although it isn't needed, I always prefix this with Call. Just helps me with tracking and debugging.

Craig