email from subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a SendObject macro attached to a form named [Contacts] which
automatically populates the email address using To
=[Forms]![Contact]!. 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?
 
Hi,


Have you try the syntax:

FORMS!MainFormName!SubformConrolName.FORM.CONTROLS!ControlOnTheSubForm


the allcap words are keywords.


Hoping it may help,
Vanderghast, Access MVP
 
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 said:
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 said:
I have a SendObject macro attached to a form named [Contacts] which
automatically populates the email address using To
=[Forms]![Contact]!. 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?[/QUOTE]
[/QUOTE]
Click to expand...
Click to expand...
 
Hi,


Didn't you mention it worked when it was on a form, but not (stopped to
work) when in a subform?
===========
(...) a form named [Contacts] which automatically populates the email
address using To
=[Forms]![Contact]!. ***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?
=============


Vanderghast, Access MVP
 
Yes that is what originally happend. When I used the syntax you provided, I
must have changed something. I did find a work around. Probably not the
most efficient solution. I created a hidden control in the primary form and
made the record source the control from the subform. The "To" field in the
macro points to the hidden control on the primary form.

Michel Walsh said:
Hi,


Didn't you mention it worked when it was on a form, but not (stopped to
work) when in a subform?
===========
(...) a form named [Contacts] which automatically populates the email
address using To
=[Forms]![Contact]!. ***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?
=============


Vanderghast, Access MVP

[QUOTE="rbb101"]
I tried the syntax below, but all that it does is write this information in
the "To" field when it brings up the email.
[/QUOTE]
[/QUOTE]
Click to expand...
 
Back
Top