text box with now() as default value

[bbatson]

Hello,

I have a text box with a date format and now() as the default value. I have a command that uploads the date field (in addition to other fields) into a couple different tables.

However, I am noticing that the time does not seem to be updating. It appears as though the time fills when the form is opened and remains constant. So, if it's 2/29/2008 6:33:18 now when I load the form, it will stay this way (and upload this value) even a few minutes later.

How can I have this text box update with the correct date/time when uploaded?

Thanks!

[missinglinq]

The Default Value is the value of the control when the record is created. To make it update you have to set it again every time you "update" the record!

Linq ;0)>

[bbatson]

Very helpful - kicked my brain back into gear. Many thanks!