Updating datareports

[Guest_imported]

Hi, I am working on a project using VB and Access. Everything is doing well except that I am not able to Refresh a datareport, means in a specific form I'm selecting the information i want to print and then It opens the DataReport but if I am trying to do another selection, the report still giving me the informaton i had before.

The project is connected to a database in access and everyime ai am doing a selection it's recorded in a temporary table in access...the problem if the report always shows the same results why the table in acess contains the new information.

So, Thanks a lot in advance

 

[StaceyG]

I had to accomplish a similar task. This worked for me:
deDVS is my data environment
rsbattererlistquery_grouping is my recordset
DRBatterer is my data report

Load deDVS
With deDVS
If .rsBattererListQuery_Grouping.State <> 0 Then .rsBattererListQuery_Grouping.Close
.BattererListQuery_Grouping
End With
DRBatterer.Refresh

DRBatterer.Show


good luck
Stacey

 

[Guest_imported]

I've tried it but it still not working

 

[sidanshu]

Just refresh your database connection.try loading and unloading it or close an dopen it.It will definitely give you the latest results.
Anshu