Report Cache Refresh problem

[usmanmajeed]

I am using SQL server as back end and Access 2000 forms as front end and also use access reports.
For displaying the report my program get the required data from the SQL server database. First I delete the old data from the access tables and then insert the new data into access table which is the datasource of my report.
when I view the report of one record (calling it from form through coding)and then go
to the next record and view its report, access display the report of the previously displayed record and also of the current record and some times only of the old record
If I close the report and view it again it display the current records report towice
Access tables contain the correct data sql queries are also correct but report show the wrong results
Most of the time reports are correct but some time not Report keep the last viewed record in its cache
I don`t know how to clear its cache
can some one help me in solving this problem

thanks