Run append query "on change"

[sinisterfrog]

I am sure I am missing something obvious here....




I have a field which tracks the location of a product [SlideData].[slocation] which changes regularly throughout the day and I would like a record of every time the field changes with timestamp.

I've made a new table [Tracking] with fields that correlate with the [slidedata] table so that I can make an append query~ but i am having issues with the criteria to limit what is being appended to that table.

My hope was that when the field [slocation] is updated in the form, that the append query would run and only add the the items where Slocation has changed~ instead (presumably because I didnt have any criteria) it added the entirety of the [slidedata] table to the [tracking] table.

Any help would appreciated.

-Matt

[June7]

Certainly need some criteria to restrict record insert. What are you using?

Post your code for analysis.

For an example of an audit tracking process review http://allenbrowne.com/AppAudit.html