Identifying Updated Records

[sharkey]

Hi

I have my table set up to add today's date as a "date last updated" field. this works for all new records but I need to flag instances where a user has amended any existing records, so that on a daily basis I can filter out anything new based on the "date last updated".

Any ideas how I can flag changes to existing records?

Apologies if this is a straight forward question I'm fairly new to Access

 

[jfgambit]

Add the following to the Forms Before Update Event

Me.DatelastUpdated = Date

HTH

 

[grnzbra]

It might be useful to concatinate the vba.environ(name) function to that date.