Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2010
    Posts
    19

    Question Unanswered: RowSource Subform

    I created an activeX of a calendar on my main form (Form1). I want the calendar to display the date that is in a subform. I cannot get the calendar to reflect the field in the subform. This is what I have in the calendar RowSource:

    Forms!Form1!Form!frm_Xas_dupK_lst.InvDt_Min

    (Form1 is the main form, frm_Xas_dupK_lst is the subform and InvDt_Min is the field that has the date)

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    ControlSource property of the Calendar control:
    Code:
    =[Forms]![form4].[child0].[Form].[text0]
    where form4 is the parent form (which holds the Calendar control), child0 is the name of the subform control (not the name of the subform itself: they can be different), text0 is the name of the textbox on the subform that acts as the Control Source for the Calendar control.

    This was tested with Access 2003 (11.8321.8324) SP3 and the Microsoft Calendar Control of Microsoft Office Version 11.0 (Class: MSCAL.Calendar.7).
    Have a nice day!

  3. #3
    Join Date
    Sep 2010
    Posts
    19
    I found it...

    subformName.Form.FieldName

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •