Pulling ALL records in subform into VBA drafted email

  • Thread starter Thread starter MacNut2004
  • Start date Start date
M

MacNut2004

Hello,

I have a form that has a subform which can have multiple records entered.
What I am trying to do is to pull in data from the form AND subform into an
email drafted by VBA within Access. The problem I am having is that VBA Is
only pulling ONE of the records from the subform into the email. Seems that
it's pulling in the record where the cursor was last at in the subform.

Any idea how i can pull ALL records from the subform into the email?

Thank you in advance!!!
MN
 
Back
Top