Answer Question
Where do I add this script in Access? Macro? Module? db.Execute "INSERT INTO [tblContactChanges] "
I would like to track all changes done to record. I found this script:
Set db = CurrentDb
db.Execute "INSERT INTO [tblContactChanges] " _
& " SELECT * FROM [tblContact] WHERE " _
& " [tblContact].[ContactID]=" & Me![ContactID] & ";"
Set db = Nothing
I am very new to scripting, so have no idea where this needs to go. The directions tell me to add this to the form, in the field "After Update". The only options it gives me to add to a form, is a Macro. I have looked at the Macro and there are several actions I can choose from, but I am not sure which one to choose. Please advise
TEXT
Uploading file and scanning for virus...
Please Wait