Calendar Control in 2007

[Mike P]

Is there a quick and easy way to add a Calendar popup next to a Date field in
a form? I'd like a button next to the field that pops up a calendar, then if
the user selects a date via the calendar, the date field will then be
populated with the calendar date.

I have read on Smart Tags, Date Picker, and writing VBX code
(Calendar1.Visible = True, but Calendar1 is undefined??), but just can’t seem
to get the logic.

Can some please provide me the syntax as how I can do this? It must be easy
and I am just missing it.

Thanks,
MikeP

 

[Mike P]

Date Picker can be used. On the form. Set the field format to Date Type
and the 'Show Date Picker' property is set to 'Show Dates'.

Then the calendar button show up next to each field and the date is
automaticlly populated.

 

[Chris Freeman]

Mike,
How did you get this to work properly. I have a field that is a date, but i
don't see any 'Show Date picker property.

I added a docmd to save the record to the afterupdate function of the
calendar, but notice that the form displays the selected date, but also the
record is still in edit mode. How can I be sure the date is being added and
the record saved?

 

[Chris Freeman]

Aha, I'm in Access 2003. Ok.