I have a form "Enter Downtime" with several text boxes for BeginDate, BeginTime, EndDate and EndTime, shown below.
The form is bound to a table, "DowntimeEvent" that has a date/time field for BeginDate and EndDate that contain both the Date and Time. The form loads fine except that both the date and time controls contain both the date and time. I need to be able to edit the dates and times in order to reflect the actual date and times the downtime occurred.
How can I load only the date in the date controls and time in the time controls, edit the controls and then save them? I realize that with the form bound to the table it automatically saves the data when I tab off or exit each control. The problem is that when I tab off the BeginTime field, for instance, the BeginDate reverts to 12/30/1899 This is so for the EndDate also. The time controls revert to 0:00.
Any suggestions?