Re: email from subform

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I tried the syntax below, but all that it does is write this information in
the "To" field when it brings up the email.

"Michel Walsh" wrote:

> Hi,
>
>
> Have you try the syntax:
>
> FORMS!MainFormName!SubformConrolName.FORM.CONTROLS!ControlOnTheSubForm
>
>
> the allcap words are keywords.
>
>
> Hoping it may help,
> Vanderghast, Access MVP
>
>
> "rbb101" <rbb101@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:9C95EC2F-B05D-4B36-BA15-C14A02964FDF@xxxxxxxxxxxxxxxx
> >I have a SendObject macro attached to a form named [Contacts] which
> > automatically populates the email address using To
> > =[Forms]![Contact]![Email]. This works fine. When I use the [Contacts]
> > form
> > as a subform in my [Activity] form, it no longer works. Is there a naming
> > convention I am missing? Also, is there anyway to copy the body of the
> > email
> > into the [Activity] form?
>
>
>
.

Relevant Pages