Calendar

I work on Access. I have a MS Calendar Control and two text boxes. When I click on the Calendar control, I should get the date displayed in the text box on which the cursor is. Is this possible?
Thanks in advance.

well when you click on the calendar control no textboxes will have the focus but you can assign the value of the calendar control to a textbox on each click if you like.

Private Sub ActiveXCtl0_click()
Text1 = ActiveXCtl0
End Sub

for example.

But I have two text boxes from which I get the beginning date and the ending date. The code you gave is applicable only for one text box. How do I set the second text box?
Thanks.

Where is the second date coming from?