Query referencing subform issue

[maw230]

I need my query to reference a combo box on the subform when the main form is open. The subform has 2 fields: Line, Item which are combo boxes sourced from queries. When the user selects a Line, I need the Item cmbo to restrict itself to values based on the Line selection.

This works fine when I have the subform opened separately, but not when only the mainform w/subform is open... So, it would seem that having the subform opened on the mainform is not the same as having the subform opened separately...

 

[boblarson]

So, it would seem that having the subform opened on the mainform is not the same as having the subform opened separately...

That is true because when it is on a parent form as a subform it is not counted as a form. It is an object which exists in the context of the subform control (control on the parent form which HOUSES the subform).

So, one quick way to get the syntax for referring to the subform from the main form is to use this:
http://www.btabdevelopment.com/ts/refer2sfrms

You can use that to find out what syntax it expects, even if you aren't trying to get a value to show on the main form.

 

[maw230]

Awesome, worked like a charm. Thanks again, Bob.