Data Reports

[JatinProg]

Hi to all
I have a problem in Data report, I am using two tables in dataenviornment and linking them to show in report.
The problem is that the report does not get refreshed for only second time, for exampe if i press the print report for the first time it shows the correct report, but after updating the record in tables and pressing print report it shows the first record or report, and after that it shows right results.

i am using the folowing code for printing report

DataEnvRpt.rsCommandRpt.Open
DataEnvRpt.rsCommandRpt.Requery
Report.Refresh
Report.Show
DataEnvRpt.rsCommandRpt.Close

please reply as soon as possible

[dee-u]

Welcome to VBF!


Try this...

DataEnvRpt.rsCommandRpt.CursorLocation = adUseClient
DataEnvRpt.rsCommandRpt.Open
DataEnvRpt.rsCommandRpt.Requery
Report.Refresh
Report.Show
DataEnvRpt.rsCommandRpt.Close

[JatinProg]

Thanks a lot dee-u
thanks 4 the nice welcome n the code (it worked)
as u know i am new to this forum culture, therefor i don't know to much of it. can u plz be me first fourm friend and help be to understand its components.
waiting 4 +ve responce
bye n tk care
JatinProg

[Hack]

therefor i don't know to much of it. can u plz be me first fourm friend and help be to understand its components.

What do you mean by 'understand its components'?

[baja_yu]

I think he means the forum; to show him the ropes, tips&tricks, FAQ and all that