Open Calendar Control Replacement on a certain date

[shutzy]

a couple of months ago i found a celndar control replacement that microsoft kindly provided. i have made a few mods that allow me to change the day/week etc. i would now like to tell it to open on a certain date. the reason is that on each of my client records i have 'Future Appointments'. i would like to be able to select a future appointment and click a button that then opens a form that includes the calendar and go to the date of the future appointment. the calendar controls the diary. whatever date the calendar is on the diary matches. so to change to the date of the appointment i need to change the calendar date.

i tried the obvious first.

[Forms]![frmDiaryMultiView]![frmCalendar].Value=#01/01/2012#

that didnt work as the calendar does not seem to recognise it.

i am totally lost with this as i dont even understand most of the code that is behind the calendar, so i dont know what i am looking for to use to open it on a given date.

thank you

 

[shutzy]

i have just solved this. the key was in my coding.

i tried
[Forms]![frmDiaryMultiView]![frmCalendar].Value=#01/01/2012#

but i forgot to refer to it as a Subform so it needed to be

[Forms]![frmDiaryMultiView]![frmCalendar].Form!.Value=#01/01/2012#

all ok now