Updated fields query

[hobbit2612 via AccessMonster.com]

Hi I wonder whether someone may be able to help me please.

I am trying to create a query that shows updated fields within a given time
period.

I have set up a 'DateChanged' field for every field I want to track in the
tables affected and I've added the statement 'Me.Field = date' to the
BeforeUpdate event on the forms that hold that date I want to track. I have
also added the coding that allows current fields to be amended.

The problem I've got is rather than the just the field that I'm tracking
showing as being updated in the query, the whole record does e.g.

Three of the fields I have are:

InvoiceNumber
DateReceived
DatePaymentSent

If I make an update on the 'DateReceived' box today, all three fields will
show todays date.

Can anyone tell me please is this what it's supposed to do or could you
please explain what I'm doing wrong.

 

[PieterLinden via AccessMonster.com]

Allen does such an excellent job of explaining that I'll let him do it...
http://www.allenbrowne.com/AppAudit.html

 

[hobbit2612 via AccessMonster.com]

Hi Peter, many thanks for replying.

I'll give the link a try, sincere thanks for pointing it out.

Regards

Chris