F
Fredrated
I have a subform of a form, and the subform has an object property defined by
a 'property get'.
How do I refer to the subform property in a query?
When I used the (sub)form originally as a stand-alone form during the
creation process, this worked:
[Forms]![fExportExcelFile].[section_id]
The query ran properly and I thought I was home free.
However, once this was made a subform of the main form, the query started
prompting for the section_id, so that reference seems to not work any more.
My most recent attempt is:
[Forms]![fMain]![Attendee Excel File].[Form]![section_id]
where 'Attendee Excel File' is the name of the subform control on form fMain
that contains the subform fExportExcelFile.
(I remain somewhat unclear on the dot-bang difference though I have read at
least one article on them.)
Thanks in advance for any help you can give.
Fred
a 'property get'.
How do I refer to the subform property in a query?
When I used the (sub)form originally as a stand-alone form during the
creation process, this worked:
[Forms]![fExportExcelFile].[section_id]
The query ran properly and I thought I was home free.
However, once this was made a subform of the main form, the query started
prompting for the section_id, so that reference seems to not work any more.
My most recent attempt is:
[Forms]![fMain]![Attendee Excel File].[Form]![section_id]
where 'Attendee Excel File' is the name of the subform control on form fMain
that contains the subform fExportExcelFile.
(I remain somewhat unclear on the dot-bang difference though I have read at
least one article on them.)
Thanks in advance for any help you can give.
Fred