On an unbound form, I have a Calendar control called ocxCal
When the form opens I would like the calendar to be set at today's date. However it opens at the last date that was used prior to closing the form. (e.g. this morning it opens with yesterday's date, 11/22/08, selected.
I have tried putting in the following code to force it to open at today's date.
<code>Private Sub Form_Load()
Me!ocxCal.Value = Date
However that has no effect. Putting the code on the OnOpen event has no effect either.
The interesting thing is that when you are working in Form Design View and shift to Form View it goes to today's date. But if you open the form from the Main Menu or anywhere else, it goes to the last date used.
Any suggestions would be appreciated.