Passing recordset at runtime doesn't give good data

[Guest_imported]

I'm working with CR 8.5 and VB 6.0
I have a report with 12 subreports. At runtime, my 12 subreports have their datasource changed by my recordsets. My database is a MS Access. When I'm copying the SQL of my recordset in Access, it gives me the right data but when I'm printing the report with my VB Application it isn't. At first when I had the prob, i just go to Verify database and it tells me that the "ado had change do you want to fix up the report"... But now, that doesn't work anymore and I don't know what to do. My recordset are Ok... Please help me

 

[Sullikit]

HI!

Check to see if your sub reports have been reset location as weel as the master report. Sometimes it does not save and must be done manually.

Kitrina Sullivan

 

[Guest_imported]

My 12 subreports are not linked to the main report. The main report doesn't have a source, a database location...

Thanks anyway

Maybe more info will help...

The problem seems to occur when the user are modifying or adding new data in the database. When I first make my report, my database was on my desktop and that's the location of the source of my 12 subreports. At runtime, the datasource is changed by my recordset and the database is located on a server. I'm connecting to it by the IP and DSN.