Using the ActiveX Calendar Control

[osito]

I have created a calendar popup on a date field in a subform. I have also created a doubleclk procedure that is correctly grabbing the date off the calendar.
What I cannot achieve is loading the activeX date into the field on the subform. I have tried every way I can think of to reference the field, but without any success. None of the guides I have give a clear example. Is there something I can do using Global or Public variables?

Some Notes:

Database Name: IMS00001
Main Form: Irrigations
SubForm: Irrigation Details
Field: DateWaterOn
PopUp Form: PopUpCal

Thanks.

 

[Jack Cowley]

Try:

Private Sub Calendar_DblClick()

[Forms]![Irrigations]![Irrigation Details].[Form]![DateWaterOn].Value = [Calendar].Value

End Sub

Hope this works for you...

Jack

 

[osito]

Mr Cowley,

Your syntax for referencing the subform control worked!

Thank you!

Phil Messina

 

[ABlair]

Can I get a copy of the calendar popup, please.

 

[osito]

To: ABlair

I'm pretty new at using this forum, and did not find a way to e-mail a reply to you. I will be happy to document what I did and send to you.

 

[Jack Cowley]

To: ABlair -

If you email me your email address I will email you a Calendar demo....

Jack