Pulling ALL records in subform into VBA drafted email

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate records of subform based on main form 3
Access Main form/Subform Navigation 0
subform record source tabbed page 2
How programmatically Delete all records in a subform 4
How to position records in a scrolling subform 5
open subform no records 1
Duplicate record in Form and Subform 0
Looping thru Subform Records 11

Top