updating text box with date picked in calendar control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the MSCAL.Calendar.7 bound to the field DateDelivery. I would like to
see the textbox for this field update when a new date is picked on the
Calendar. But it appears that the record needs to be saved before it will
show the new date.

The Calendar has the OnUpdated event that I've tried to use to run a macro
to save the record, but the macro never runs when a new date is picked.

So I need to figure out what event I can use to save the record, but the
calendar on has a few.

Thanks,
 
The events available under the calendar control will not enable you to do
what you desire. However, you can add a command button to your form next to
the DateDelivery field, perhaps labeled "Use Calendar Date", and place the
following code under the On Click event...

Dim SetDeliveryDate As Date
SetDeliveryDate = Form_<YourFormName>.<YourCalendarControlName>.Value
Form_<YourFormName>.DateDelivery.SetFocus
Me.DateDateDelivery = SetDeliveryDate
 
Back
Top