re-updating automatic date field

[ranfan]

I have a table with a DATE field that is automatic, =Now(), when data is entered inot the record. Can this be updated if new data (via a form)is entered into the record? thanks.

 

[KenReay]

Hi

You have a filed in table whose default value is now() ?

To update it:

On form, put control bound to that field

in before update event of form put Me.MyDate = Now()

where Mydate is the name of your control Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[ranfan]

thanks, I'll try that!