Cascade Combos on a SubForm Tab - Parameter Value Error

[Huddle]

I found several post that address this common problem but I'm just not getting it. The cascade works when you're in the subform but not when you're in the main form (subform in on a tab control). It asks for a Parameter entry.

Main Form: Fm_Inventory
SubForm: SubForm_Countermeasures
1st Combo Box: cmbsystem
Next Combo Box that cascades from 1st Combo Box: cmbtype

Here is one of the Row Sources for cmbtype I've tried. (under the System Where in the Q)



[forms]![Fm_Inventory]![SubForm_Countermeasures].[cmbsystem]

[boblarson]

See if this helps:
http://www.btabdevelopment.com/ts/refer2sfrms

[Huddle]

Actually that confused me more.

[boblarson]

Actually that confused me more.

Okay, let me try to explain.

Your syntax is wrong.

The link was showing you HOW you can get the right syntax by using the Expression Builder.

Does that help push you in the right direction?

[Huddle]

So I think according to the tutorial, and other posts I read, that the correct syntax would be:
[forms]![Fm_Inventory]![SubForm_Countermeasures].[Form]![CmbSystem]
But that gives me this:
Microsoft Access can't display the field for which you entered Where in the Total Row.

[boblarson]

So I think according to the tutorial, and other posts I read, that the correct syntax would be:
[forms]![Fm_Inventory]![SubForm_Countermeasures].[Form]![CmbSystem]
But that gives me this:
Microsoft Access can't display the field for which you entered Where in the Total Row.

If you used the method I showed, then you would likely have this as the end point:

[SubForm_Countermeasures].[Form]![CmbSystem]

without the first part.

But the key is also that it would be referring to the subform CONTROL (control on the parent form which HOUSES the subform, but is not the name of the subform itself, unless the name of the subform and the name of the subform control are EXACTLY the same).

[Huddle]

Yes I did get that but I added the [forms]![Fm_Inventory]! according to some of the other postings I read.

It does work now. Apparently the Control is the same name as the SubForm.

Thank you for your help.

[boblarson]

Yes I did get that but I added the [forms]![Fm_Inventory]! according to some of the other postings I read.

The full form reference is only required if you are referring to it from a form that is not the parent form (or another subform on the parent or the subform).