Active X Control - Date selection

[s.booth]

I am trying to use the Active X control that shows a range of dates that you can choose from.

I have an unbound box that I want the date choosen from the date control to show. My prblem is the first time I choose a date it works fine but if I change the date it does not update the unbound box with the new info. I have used got focus event.

 

[Fizzio]

Are you using the calendar control?

If so, go into the code for the form it is on and add

Private Sub NameofCalendar_OnClick()
Me.NameofTxtBox = Me.NameofCalendar.Value
End Sub
The OnClick event is not available via the event properties, so you have to add it manually.
HTH

 

[golgo1]

Thanks, for the above info, helped me out as well. Further on that.. is there any way to have the first(or any) day selected when a new month or year is selected from the pulldown menu? or at least update the textbox when that happens?