Data Report question

[cedx]

Greetings,

I have a Data Report that draws data from Data Environment, it works fine the first time I use it. When I change the data in the database table and call up the data report again, it shows the old data.

How do I get the data report to show the new updated data?

I am using VB 6.0

Thanks in advance.

[vb_dba]

In your code, before you open your report, add a statement similar to the following:

If DataEnvironment.rsConnection.State <> 0 Then DataEnvironment.rsConnection.Close

rsConnection is the recordset object of the connection you are using.

This will refresh your DE.

Hope this helps,

Chris