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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top