I have a connection command which loads data from a local table inside Access 2000 database.
However, though the contents of the table changes by using the application, the DataReport displays the state of the table when you clicked on a given button, and though it reads from the same Access 2000 table, it still displays data at the point when you clicked that given button.

I see there are events like Activate, Initialize, but although I called my method to clean and refill the Access 2000 table, the DataReport still displays old information.

How can I regenerate the DataReport, or refill with new data without the need to close the application completely and start it again?