A Combo box allows changes in the status recorded for each record in a table (A).
I would like to accumulate a historical record of what's been changed, and when. So I want to set up a new table(B), containing 3 fields: an index(to link back to the main table A), the new status, and the date/time when it happened.
What would be the best trigger for an event associated with the Combo box? And what code will enable me to create a new record each time for the table B?