instant db refresh

[kodemonk]

i have connected msaccess database thru intrinsic data control by drawing data control on my form.i also have a data report .

the problem is when i enter new records and save it ,it goes into the database ,but when i view the data report,the latest entered record doesnt get displayed in the data report.
when i close my application and again open it,now if i access the data report i am getting all the contents of my database.


now my question is

1>is it possible(and how to) to view the latest added content in my data report without closing my application and starting it again.

[wes4dbt]

Try this

If deData1.rsData.State = adStateOpen Then
            deData1.rsData.Close
        End If
        rpReport1.Show

deData1 is the dataenvironment used by the report
rsData is the name or the recordset the DE uses.

[kodemonk]

i got an other solution from some other forum.

after .show property,using the below code.


DataEnvironment1.rsCommand1.Requery
.it works well.