RowSource Subform

[abenitez77]

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)

 

[boblarson]

It is CONTROL SOURCE (not record source)

Also use the builder to get the correct reference. See here for how.

 

[abenitez77]

That worked! Thank you.

 

[abenitez77]

I found it...
subformName.Form.FieldName