Event Calendar/Diary

[sam_antoine]

I have created a diary in Access but I need some assistance. I created a form called frmDiaryPlanner which consist of 24 fields named 0700, 0730, 0800, 0830...1930 respectively. On DOUBLECLICK on any of the fields, a form called frmDiary opens. I want the subject field on this form to equal the data in the time field (e.g. in 0700). I have done the following:

Private Sub Ctl0700_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmDiary"
frmDiary.Subject = frmDiaryPlanner.[0700]
End Sub

but it does not work. Can someone please lend a helping hand.

 

[pbaldy]

Try:

Forms!frmDiary.Subject = Me.[0700]