Selecting a Date from a Calendar in a Form

[Cesar]

Hello All,
I need to query my data between 2 dates(and a report from this query), since
this is a very frequent task, I created a Form where the user can select
these two dates, but instead of having the user typing the "Initial Date" and
"Final Date" I want to use a Combo Box to enter the dates, when On Key Down
make a Calendar visible, where the user can select a date, which will pass to
the Combo Box and Close the Calendar, same thing for the "Final Date", the
"OK" button in the Form will run the query with the BETWEEN dates previousuly
selected.

Thanks in Advance.

 

[Cesar]

Hello again,
I forgot to mention that I can make the Calander visible when click on the
combo box, I have this in my code:

Private Sub Combo1_CLick()
Calendar1.Visible = True
End Sub

Where I need help is how to pass the selected date on the Calendar to the
Combo Box, which at the end will be my Criteria in the Query. Also Close the
calander once the date is selected.

Thanks Again

Thanks