422,027 Members | 1,149 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 422,027 IT Pros & Developers. It's quick & easy.

How do I loop through subform data in Access/vba for exporting to Word

P: 1
Hi,
I Really need help, can't find the answer anywhere.

I'm trying to export data from access to word. Mail merge doesn't have the features I need.

Ok, there is a form with a subform that when filled in saves the data to the tables and I've made a button that fires a vba script which exports the data to word. This works perfectly. The problem comes in with the subform. I don't know how to loop through the subform data related to that form entry.
I've got it to retrieve the first entry on the subform's table, How do I get it to loop through?

I can't get the upload to work, here's a link to a google drive folder if you'd like to see the database in action.
https://drive.google.com/open?id=0Bw...Dh2UWRMVllvYnM
Sep 7 '17 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 30,549
Hi Gregory.

I'm not really sure where you're struggling but it may help to know how to reference a subform (Referring to Items on a Sub-Form) as well as that each bound form has both .Recordset & .RecordsetClone properties.
Sep 7 '17 #2

Post your reply

Sign in to post your reply or Sign up for a free account.