Web Development

Ask something
Discussion Locked

VB6 Data Report

0 helpful
5 replies

by rangling

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am developing a VB6 application using the Data Report Module, I need to be able to generate reports for different clients, however i keep getting the same report even though i change the data. How do I update the recordset?

5 replies

by madestroitsolutions

Ha my friend, I was having the same problem with this stupid microsoft data reports. Its really annoying because no matter what you do, refresh, rebind, etc, it keeps showing the same data. Well, after good 3 days of browsing Microsoft Online Document maze (Knowledge Base), I finally found the answer to the problem: You need to close the recordset. That is the only way, the report truly unbinds. Here is how:

Include the following line before you modify the recordset with the new data:

'(assuming recordset name = Rs01)

if Rs01.state = adstateopen then Rs01.close

And thats it, it will refresh every time.

Good luck!

This discussion is closed to new replies.