I'm trying to generate a report in VB6 by using Crystal connect to an Access Database.

And I use DSN as the connection. My query is so complicate, so i decide to create a temporary table that has the same field as in the crystal. My crystal report connect to that temporary table.

Whenever I want to generate a report, I pick some data from my flex grid and Insert them into the temporary table, then show my report.

the problem is that the data record in the crystal is different from data Access Database. But when I click a refresh button at the top of Crystal page, it become the same as in Access Database.

I don't know if anyone can help me to write a code to make it refresh automatically. I don't want the user to click the refresh
button everytime.


Thanks,