I have created a module to send an email whne a form is completed. I wnat a
command button to click and execute the module. I can't find where I can
select a module to run at the "on-click" property. How do I do this?

On Fri, 7 Nov 2008 15:05:01 -0800, Dave Couch wrote:

> I have created a module to send an email whne a form is completed. I wnat a
> command button to click and execute the module. I can't find where I can
> select a module to run at the "on-click" property. How do I do this?

A module is just the place that you place your code.
What is the name of the sub procedure you placed within the module?
Let's say it's called
Sub SendEmail()

Using code from a command button Click event on your form, code:

SendEmail



--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

On Nov 7, 5:05*pm, Dave Couch <DaveCo...@discussions.microsoft.com>
wrote:
> I have created a module to send an email whne a form is completed. *I wnat a
> command button to click and execute the module. *I can't find where I can
> select a module to run at the "on-click" property. *How do I do this?

In the design mode of the form, open the properties for the command
button. Scroll part way down to the OnClick event and click the
elipses (three dots) Select "Code Builder", and call your code from
there.

Hope this helps,
Chris M.