Calendar

[shersu]

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.

[Ephesians]

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.

[shersu]

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.

[Ephesians]

Where is the second date coming from?