Date update question

[EjS]

I have a date field that is set to automatically put the current date in when a new record is entered. Is there a way to make the date change to a new date if I update the record? Say I make a change today, and the date field automatically changes to today? Thank you!

 

[chrismcbride]

You ought to be able to put a line in the AfterUpdate of your form that updates the date field...

Me.RecordDate = Date()

HTH
Chris

 

[EjS]

Thank you. I put that expression in and changed a record but it didn't put today's date.????

 

[chrismcbride]

Sorry, should have been more clear. Where is says RecordDate you should put the name of the control that hold your date value on the form. I am assuming that you have bound this control to a table field as well...
Chris

 

[EjS]

Thanks for the help--I'm a beginner!

 

[chrismcbride]

OOppps , Typo
many appologies!
Chris