Printing a report from a VBA array

[vasasj]

I have a report already made in Access that I need to pass an array too and to print the contents in the array. I need the option of grouping on a specfic set of records in the array. I can get the first group of records printed, but I have not been able to get the report to repeat and print the next group of records. Here's an example.

Calling Number:
77429003-009
Drawing Number:
717700817-001
77429004-001
Calling Number:
77429004-001
Drawing Number:
77400800
77420001
79P070000

 

[Bryan F]

i've never attempted what you are trying to do, but the only logical way i could see to do it would would be to iterate through an ADO recordset object and assign each index of the array to the recordset as fields...open the report in design view and assign the recordset object to the report, then reopen it in preview mode. That's just the first thing that comes to mind... if you don't get anymore replies and want to try it out, post back for some help with the code.

 

[vasasj]

Bryan F
Could you send me a copy of the code that you are talking about.

 

[Pat Hartman]

Look up this article in the knowledge base. You'll have to adapt it but the basic idea is there:

How to Use a Multi-Select List Box to Filter a Form