vb datareport

Hi,

I have created a DataReport that is bound to a DataEnvironment for it's recordsource and I have a problem with the report not refreshing until I close out of the application and get back in.

For example, before I first run the report, I can enter some data and then run the report and it's fine. Then, if I close the report (not the application), change or add data, then run the report again, it still only shows the previous data, without the latest updates. It only shows once I close out of the application completely and then get back in and run the report.

Any ideas?

RptAgent.Refresh
RptAgent.Show

can i see your code?

Consider binding an ADODB recordset to the data report directly at run time and drop usage of data environment.

http://www.vbforums.com/showthread.p...ataenvironment

Moved to reporting

Try thes

Code:

---

If Datarenvironment1.rslots.State = adStateOpen Then
        Dataenvironment1.rslots.Close
End If

Report1.Show

---

You'll find alot of information already posted on this problem by searhing this
forum.