Question

MS Access ActiveX Control

Microsoft Access, ActiveX, Calendar control

I am using a MS Form where I am trying to fill in a couple of date fields from a Calendar I inserted using ActiveX controls. How do I go about doing that?
Thanks,
Asuasol

Hi asuasol
On your form that has the Calender (name: slct_date), create a comand button, and a bound or ubound field (name : W_Date) with format short date
set the On Click of the command button to Event procedure :
W_Date = slct_Date
When you select a date from the Calender click the command button, the date on the calender will appear in the W_date field.
You can create as many Command buttons and relate it to specific fields.
Good Luck