Saving Dates

[wop0703]

I have a form in which an individual has to input a date then choose a category. This is for keeping an individual's time. I want the date that user user first inputs to be the default date that is shown automatically unles the user changes the date, at which time, I want the new date to be the default. Can anyone tell me how I could do this?

 

[Tim L]

You could store the date in a table for persistence between sessions or in a variable for a session.

Tim


Question Not Answered As You Expected? Try This.

 

[godofhell]

Set a field in your table to store the date as a date format then on the form set the Before Insert event of the form so that it writes the value to the date field to the text box.
Private Sub Form_BeforeInsert(Cancel As Integer)
txtDate.Value = Date
End Sub

Or if you want to see the date and time change the Date to Now()