Force a new Group detail section in code

[CautionMP]

I looked through the forum and did not see this topic.

I have an ubound, memory resident, ADODB.Recordset that holds the data I need on my report. Because the data is not stored in a table I cannot use Report.RecordSource property. The code is all written to generate the report but here is my problem. I can write all my records to the report but I can't figure out how to trigger Access to create a new detail section within my group.
e.x. Report is done writting all the records for 07/23/04 so I need the report to write a group footer, check if more records exist and if so write another group header and start writting the records for 07/24/04.

Anyone have any ideas?

FYI the report currently writes a group header (with the first date in the recordset), writes all the records (even if the date changes), then writes the group footer with all the correct calculations in it.

Thanks in advance for any help.

 

[dhookom]

I would push the data to a temporary table and then create a report based on the table.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[CautionMP]

Because of the environment this will be used in I cannot store the data in a table and I'm trying to avoid creating a .dat file for each user.