Access: Popup Calendar in a form/subform in Access 2003/XP/2000/97

Question: I'm usingAccess 2003/XP/2000/97, can you explain to me how to create a popup calendar in a form and also how to create a popup calendar in a subform?

Answer: There are may different ways to code popup calendars. We've provided a download to demonstrate how popup calendars work in both forms and subforms.

Download version in Access 2000

Download version in Access 2002

Popup Calendar in a Form

Here's what we mean by a popup calendar in a form. Below is a form that has a date of birth field.

When the user clicks on the button to the right, a popup calendar will appear.

The user can then select the date from the calendar object and click on the "Set Date" button to return the value to the originating form.

Popup Calendar in a Subform

Here's what we mean by a popup calendar in a subform. Below is a form that contains a subform. In that subform, there is a date of birth field.

When the user clicks on the button to the right, a popup calendar will appear.

The user can then select the date from the calendar object and click on the "Set Date" button to return the value to the originating form/subform.