Calendar icon

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I get a calendar icon on a form so the user can select and a calendar
will appear so they can select a date and it will then populate that selected
date in my date field on the form?
 
Create a new form and while in desing mode then go to menu Insert/active x
control. Scroll down until you see Calendar control 9.0 and add it to your
new form.

Then create a control/button that will open your form with the calendar.
Then in the Close form event of your calendar form, put something like this
to assign the selected date to the desired control :
Forms(frm).Controls(ctl) = Me.MyCalendar.value

That should do it.
 
Back
Top