Unanswered: How to use .FormFields to fill numerous records under the same column
Hi, I'm looking for some help on the following:
I am using .FormFields to fill a quotation template in Word, but the subform I am retrieving the data from has rows of records under each column and I need to send more than just the first row to fill the required bookmarks in Word.
A quotation is made in access as shown on screenshot 1. The data on this form then fills bookmarks in Word shown on screenshot 2. The quotes can contain more than one product ID (I've shown 2 in the list). When i export this to Word it fills only the first column of my table. I need to specify on the FormFill to retrieve data from the second row (record 2) to be able to fill the second column in my Word template.