i am using vb 6.0 data report bound to a data environment. pls tell me how to automatically refresh the report

Question

im using Visual basic 6.0 as front end and ms access as back end.
this is my problem:everytime i add a new record, it will not reflect immediately on the data report (which is bound to a data environment) when i view it, unless i will close and reopen the entire program. how can i view the newly added records on the data report without closing the entire program? what's the code? in what event shall i place the code? pls reply asap. thanks a lot.

Answer 1

Is the 'data environment' just a view of the query result from the database? And if so, does the environment get refreshed or requeried each time you make an edit?

The problem might be that you're looking at a static picture of the data rather than a live view of the database.

Make sure the query/environment is updated every time you edit data, then follow that by refreshing the form or report, like frmReport.refresh

hope that helps