ActiveX Calendar events...

[Sid]

On the Calendar 8 Activex control in Access 97, how can I get an event or
run code when the month or year is selection changed. I wanted to update my
surrounding form's controls according to changes made in Calendar. I now
send Calendar the current month and first day when opening with:
D = Day(Date)
M = Month(Date)
Y = Year(Date)
Me!ActiveXCalendar = DateSerial(Y, M, 1)
I can do it manually with a Button or Lost Focus that uses:
ActiveXCalendat.Value
Thanks
Sid

 

[Jonathan Parminter]

-----Original Message-----
On the Calendar 8 Activex control in Access 97, how can I get an event or
run code when the month or year is selection changed. I wanted to update my
surrounding form's controls according to changes made in Calendar. I now
send Calendar the current month and first day when opening with:
D = Day(Date)
M = Month(Date)
Y = Year(Date)
Me!ActiveXCalendar = DateSerial(Y, M, 1)
I can do it manually with a Button or Lost Focus that uses:
ActiveXCalendat.Value
Thanks
Sid

Hi Sid, use the calander object click event. for example
control with name atxDate use

private sub atxDate_Click()
txtDate.value=atxDate.value
end sub

Luck
Jonathan

 

[Sid]

Thanks Jonathan
But, I don't see a click event in the ActiveX control I'm using. The only
events are:
On Updated, On Enter, On Exit, On Got Focus, and On Lost Focus. I can't
select and view properties for individual controls on the ActiveX calendar,
like Month and year selectors.
What am I missing?
Thanks