I need a bit of help
I'm using VB6 with Access tables, I have a problem refreshing report
data using the VB6 report designer component.
I've created a data environment with two connections which both take
data from a 'template' table, the table uses the 'DELETE' and 'INSERT'
methods so that I can run a number of queries from the application's forms
making the results available from this table.
I've created two reports each one attached to one of the data environments
connections. When I run each report for the first time, both reports work
fine, report query 1 deletes and inserts the template table then the report
displays the results etc.
If I try to run another report query say using different values the new results
do work on the table but unfortunatly the report data is not updated.
The obvious report.Refresh method should work but does not, has anyone came
across this problem ? and recognise something that I've missed or something
I'm doing wrong.
Also am I doing this the right way as far as the data environment and reports,
i.e. one data environment, two connections, two reports ?
All help appreciated.
Thanks in advance