I created a temporary table in ACCESS format for storing temporary data.
I let the user to put some value and store this value in the temporary table.
And I created a Data Report to generate report base on the table. The question
is, if I first run the program, the Data Report is OK. When I run the report
again by changing the value of the table and run the report again, the report
remains the previous data. The program criteria is as follows:
-- First let the user key in input
-- delete all the records in the table to make the table only holding 1 record
-- add the user input to the table by click a button
-- display inserted record in MSHFlexgrid
-- activate report by clicking a report button

Any help provided is very much appreciated. Thank you