auto update in data report

[enigmagirl122]

hello!
im using data report for my vb6 and ms access. my data report is working w/o errors. but the problem is if i changed/update something on my database (database connected to data report). the updates that i made are not seen on my report.for example originally the database has 10 records the 10 records will also be shown on my data report. but if i changed my database and add another or remove record. the report stays 10 records. how do synchronize the database and data report.

thanks...

[vb5prgrmr]

is there a refresh method?

[Hack]

Moved To Reporting

[wes4dbt]

If you're using a DataEnvironment you probably need to close or requery the recordset.

If Dataenvironment1.rsusers.State = adStateOpen Then
        Dataenvironment1.rsusers.Close
End If
DataReport1.Show