getting a property on a subform

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RecordsetClone on a subform 3
Subform of a subform 1
Open a form with a subform showing specific data 3
Syntax for Referring to a subform 3
Locked Subform still lets me delete a record 2
Passing a value from subform or main form to subform query 4
subform total behaving strangely 2
Access Simple Access subForm question 0

Top