Pop Up Date Picker

I have a few textboxes which are populated from a database. I was wondering if there was a way to create a pop-up date picker which would pop up once they entered a textbox and then return the value to the textbox. I have about ten different dates so I would hate to create ten different date picker controls that return the value. Any ideas?

have you explored the monthview component in the microsoft windows common controls?

Yes. I guess my question is this.

Is there a way to write a function so that I can just have one monthview control hidden on the page. Have it become visible when they enter a textbox and automatically know to send the chosen date back to that textbox?

have you explored the monthview component in the microsoft windows common controls?

what i would do is

dim clickedbox as textbox

set the visible property of the monthview to false and add these


Private Sub MonthView1_DateClick(ByVal DateClicked As Date)
clickedbox.Text = DateClicked
MonthView1.Visible = False

End Sub




Private Sub Text1_Click()
Set clickedbox = Text1
MonthView1.Visible = True
End Sub


then duplicate the text1_click sub for the other boxes. you could even make the top left pixel of the monthview equal the bottom right of each textbox for convenience

Worked perfectly...thanks.