Unable to Track an Update

[Learn2010]

My program uses an SQL backend. I do not have permissions to change anything in it other than data. One of the fields in a table is LastContactDate and I do not have any defaults for anything involved in using this field. When a record is opened for viewing and I close it, that field updates to today's date. If I view it only, I do not want that to happen. I have stepped through it and can find nothing that affects it. Is there a way to see which queries just ran?

 

[pbaldy]

Check the form level events (focus, update, etc) and see if anything is running to update that field.

 

[Learn2010]

I found it. It was in the load process. It updates when it is accessed by a user.

Thanks.

 

[pbaldy]

No problem. I'd put that in the before update event, which should only run if they change something.