Notification of update

[Guest]

Need some help.

I have a continuous form with a field called "Appt". Each day I upload a
file into a temporary table. Inside that table is a date field. An update
query takes the date field and updates "Appt" and then another query deletes
the temp table.

I could upload and update this field multiple times in a given week, which
is ok because 9 times out of 10 the data stays the same. The one time is
does change, I need a way to "know" it changed. I would prefer to be able to
visually tell on the form whether it be a counter, color change, or some sort
of flashing notification. How can I accomplish this?

 

[Guest]

Put criteria in your update query to compare temp.field to updateTable.field
and add a field like Updated On: Date() so it will tell you when it updated.