Changing value of a field on update

[dealwi8me]

I have a form in MS Access and i want when the users modifies data of tis form the field EntryDate(in the table) to get equal to Date()(todays date).

I guess it's easy to be done but i have no idea of VB ...

I will be gradefull to any suggestions.

Thank you in advance!

 

[M8KWR]

I believe you can use the On_Dirty procedure to do this.

I use A97, and does not have this event, so i have not tested it - and believe it to do what you want.

If you put your code into this event, which would be something like:-

FIELD_NAME = Date

I hope this helps, and work for you. If not let me know...

 

[Pat Hartman]

The best place is the FORM's BeforeUpdate event:

Me.SomeFieldName = Date()

 

[dealwi8me]

It works!
Thank you!