VB6 Datareport not printing up-to-date data...

[GWhiz]

I'm writing a VB6 program which accesses/updates an Access-created database.<br>
<br>
Updates are posted to database as they happen (have looked at database immediately after update has executed) -- but VB6 datareport is always one step behind. If I terminate and re-start VB6 program, then print datareport, updated information shows up.<br>
<br>
Have tried to refresh/requery DataEnvironment connection as datareport is activated, but to no avail -- must terminate then re-start for datareport to show updated info, even though database shows updated info immediately (when looked at in Access environment).<br>
<br>
Any suggestions?

 

[marcseys]

Every time before you show the datareport, you have to "requery" the datasource you're working from.<br>
<br>
rgds<br>
Marc<br>
<br>
marc_seys@oilpackers.com