Check Box + Email

[nx69]

I want to built a macro which will check a check box and open a new form. How can i do that?

And also how can i built an other macro to send an email and for the email address to automatically take the values in field call E-mail in tblMembers. [tblMembers]! doesnt work

Thanks.

 

[spacepro]

I know you want to create a macro but if you use code then the checkbox question would be :

me.checkboxname = true
docmd.openform "yourformname"

As Far as the email question do a search of the forum for 'outlook' and I am sure you will find loads of posts on this.

I think in both scenarios you are best using VBA code.

Hope this helps you in your project.

Andy

 

[=TB=]

I know you want to create a macro but if you use code then the checkbox question would be :

me.checkboxname = true
docmd.openform "yourformname"

As Far as the email question do a search of the forum for 'outlook' and I am sure you will find loads of posts on this.

I think in both scenarios you are best using VBA code.

Hope this helps you in your project.

Andy

me.checkboxname = true

should that not be

me.checkboxname = -1

or does True work as well?

 

[spacepro]

Both apply to the situation. Well it works for me anyway.

Andy