refresh 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?

Thanks,

Dan

VB Code:

Private Sub cmdShowReport_Click()
  Dim dr As New DataReport1
 
  Set dr.DataSource = DE1.rsTest 'not sure about this line
 
  dr.Show
End Sub

try something like that

:)

after dr.show
try with dr.refresh

Hiran

sorry... before dr.show... try with dr.refresh

Moved to reporting section

You may try a client-side cursor also.. or requery the recordset before showing...