On a form I have a date field. The user enters a date sometimes in the past, sometimes he may enter today's date.
Then on the form I have an [Add Record] command button. When the button is clicked the form displays a new record but the date is populated with 12/30/1899 !!!! What? Why?
Here is the onclick code of the command button:
Private Sub txtTranxDate_AfterUpdate()
Me!txtTranxDate.DefaultValue = Me!txtTranxDate.Value
All I want the date field to populate with is the last date entered in the record prior to the new one.