In case you delete all records from table(s) and insert new info:
1a) When you update a single table only, you need a table like tLastUpdated: UpdateDate and add a row with some date into it. Into procedure which runs update query, you must add row
Code:
UPDATE tLastUpdate SET UpdateDate = Date
1b When you update sevaral tables (egal with same procedure, or with different ones), you need a table like tLastUpdated: TableName, UpdateDate. Into procedure which runs a update query e.g. for tTable1, you must add rows
Code:
DELETE FROM tLastUpdate WHERE TableName = "tTable1"
INSERT INTO tLastpdate (TableName, UpdateDate) VALUES ("tTable1", Date)
Here is used INSERT INTO instead of UPDATE, as having multiple tables in update list automatically assumes, that you may want new tables to be updated in future, and it is easier to delete existing and create new records instead of checking every time is the table in update list or not, and then decide between INSERT and UPDATE.
In case you update only part of records in table(s), you need a field UpdateDate in (every) table updated. The field is updated as part of update query, like
Code:
UPDATE tTable1 (Field1, Field2, ..., UpdateDate)
SET Field1 = SomeValue1, Field2 = SomeValue2, ..., Date)
When you want to know last update made in form for every row in table(s), you also need a field UpdateDate, which is linked to hidden or disabled text box (txtUpdateDate) in form. In BeforeUpdate event of form you add a row
Code:
txtUpdateDate = Date