Automatic last modifed date

[tikkat3]

I know there are a number of other threads on this topic on here, but having looked at them all, I cannot make my "Date Last Amended" field autoupdate when a change is made within a record.

The table field is tblDate_Last_Amended; the form field is frmDate_Last_Amended.

I have tried a number of different things, but none work, all come up with an error message which will not let me proceed without shutting the form down.

I am now totally confused and do not know where to begin. Help!

 

[MStef]

Look at "DemoLastModifDateA2000.mdb".
Look at Table1, Form1, VBA.
Open Form1 and try.

 

[tikkat3]

Thanks MStef, finally worked out my error. I had not made the 2 entries, just for the field and not the form.