How to store changes in Access table cells?

Question

Visual Basic

There is a form in which the operator enters some values, from the selection he selects one of the cities presented in the list. His choice is recorded in the "main" table. At the same time, I would like this data to be also sent to the "Archive" table and accumulated there. In principle, I have already written the code that will save them there. The problem is that I can’t understand how to implement a table that stores the history of cell changes, and how to access it later, because it turns out that the records in the “index” field in the “main” table should be associated with the name of the fields from the table "Archive"... Tell me please, how and in general is it possible to implement the storage of measurements in Access tables?
Base example

Answer 1

Well look. Here you have a key field in the main table, it should be in theory.
Id_general
Next you have a table of cities, let id_city be in it.
And here you have the final table Archive.
Id_history Id_general Id_city Date_Change.
Id_history - autoincrement. And the rest of the fields - which line did you change, to what, when.
Having made a selection by id_general and adding sorting by Date_Change, you will get a history of changes.
You should add your own data schema. And - name the tables with the prefix tbl, preferably in English. There are subtle glitches with Russian names.