I have a date stored in a field called gDate.
As the user creates a new record in the table I want to make this the default value of the date entry field called TTrack_Date_In.
I have the following logic in the Current event of the form:
if me.newrecord then'
me.TTrack_Date_In.DefaultValue = gDate
This results is a very strange value (12/30/1899) in TTrack_Date_In. I remember that defaultvalues always have to be characters but I'm not sure how to get the date in gDate to show up correctly as the default value in TTrack_Date_In.
Any one know the syntax?