Looking for example of creating report in Access with VBA
Posted on 2008-10-30
I am looking for a sample of creating a report and populating the detail record(s) fields using VBA. I have to gather date using several queries and then summarize to build the report, and doing so programatically seems to be the only option (the standard grouping features, etc. with the access reports don't cut it). I understand how to reference the report unbound fields, but am not sure how to reference repeating fields in the details and other group levels.
I have the initial report structure built in access and am not sure if I can use that as a starting point or I will have to create it from scratch with code.