date from one field as default

jwf

Registered User.
Local time
Today, 00:01
Joined
Dec 5, 2012
Messages
18
Is there a way to use the date entered in one field in a table as the default date on another field in the same table?
 
Not as a default in the table.
You could use VBA on any form that uses the table, in the AfterUpdate event of the control for the first field to set the second fields value as the same.

EG

Private Sub Field1_AfterUpdate()
Me.Field2 = Me.Field1
End If
 

Users who are viewing this thread

Back
Top Bottom