Date and Time Field in Form won't update in table

[Guest]

Hi,

I used the =Now( ) in a form to display the date and time. It displays when
you look through the records, but I can't get the date and time to populate
the table that is linked to the form.

Can you explain how to fix this?

Thanks in advance,
Emily

 

[Guest]

You can't put that as the control source as that will not store it in the
table. If you put it in the text box's DEFAULT property then it will
populate it when a NEW record is created and then you can bind the control
source to the field name.

If you want it updated whenever a specific control is changed, you can put
it in that specific control code as:

Me.YourDateTimeTextBoxNameHere = Now

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista