Simple audit by posting whole record to seperate table

[William Demuth]

Good Morning

I need a simple audit capability

I have a table (Called Master Active List)

I have an empty duplicate of it called History of Master Active List. (Identical fields, with the addition of a distinct ID (primary key)

I have a form where the master can be changed (Called customer details)

When any change is made I want to post the whole record to the history table

1 - Am I correct I no longer need a form based one,(office 2013) and can do one on the data table itself?

I want to capture everything, can this be done with a wildcard, or do I need to go line by line?

The master table has a ton of fields

 

[burrina]

This can be done using a Append Query. Simply add the Origin table to the gird, add the * to the grid and then select Append and choose your destination table.

HTH

 

[William Demuth]

I have that much down

My problem is it copies ALL the records from the master to the history, and not just the specific record on the form.

I suspect I need to pass a variable from the form to the query

 

[burrina]

YES, you need to select the record via the Primary Key.
[Forms]![YourFormName]![PrimaryKey] using a Group By.


HTH