In what context? After you change a record on a form? After you update a record with a query?How do I get this field to automatically update in the table to "today's date"?
Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.yourDateField = Date()
End Sub
Hi
I have a table which has a date field in it, where the default value is Now().
How do I get this field to automatically update in the table to "today's date"?
Thanks
Maria
i have tried that but it didn't work on my access 2010.What you have done (based on the information you have provided) is set the Default value. You need to write the code inside the Form's Before update..
Code:Private Sub Form_BeforeUpdate(Cancel As Integer) Me.yourDateField = Date() End Sub