Form works, Subform gets error

[jlclark4]

I have a subform within a Search form. Everything works except when I try to work through the cascading combo boxes. In the orginal form, it works.



Orginal: FmInitial
Search: FmSearch
Subform in FmSearch: SubFmInitial

I get "Enter Parameter Value : Forms!FmInitial!cboActRoot" when I try to go to the second box. I tried changing the SubFmInitial to FmInitial thinking that might have been the error but it didn't work. And if it makes a difference, this field does not have to work in the FmInitial but needs to work in the Sub Form.

Any ideas as to why before I screw the whole thing up trying to figure it out?

[RuralGuy]

See if this links helps at all: http://www.mvps.org/access/forms/frm0031.htm

[jlclark4]

No, that didn't help I was using something like that to create the search functions though...any other ideas?

[RuralGuy]

SubForms are *not* listed in the FORMS collection, only MainForms.

[jlclark4]

So i changed it to Forms!FmSearch!cboActRoot and the error goes away but then there isnt a list anymore. just a blank combo box...The following is the row source for each of the combo boxes for the cascading effect.

cboActRoot: SELECT DISTINCT tblRootCause.Category FROM tblRootCause ORDER BY tblRootCause.Category;

cboActSubCat1: SELECT DISTINCT tblRootCause.IssueDetail, tblRootCause.Category FROM tblRootCause WHERE (((tblRootCause.Category)=Forms!FmSearch!cboActRoot)) ORDER BY tblRootCause.IssueDetail;

cboActSubCat2: SELECT DISTINCT tblRootCause.DetailType FROM tblRootCause WHERE (((tblRootCause.IssueDetail)=forms!FmSearch!cboAct SubCat1));

[RuralGuy]

In order to reference a control on a SubForm, you need to go through the MainForm reference in the FORMS collection.
Forms!MainFormName!SubFormControlName.FORM!Control NameOnSubForm
Remember that SubFormControls do not have to be named the same as the SubForm they display.

[jlclark4]

So, the subform itself is a control?

IE =Forms!FmSearch!SubFmInitial.Form!cboActRoot

[RuralGuy]

Forms are displayed on other forms by the use of a SubFormControl.

[jlclark4]

Gotcha, thanks for the info. It finally worked. I had tried doing something similiar to this once before but it didn't work. But apparently I was on the right track. Thanks again!

Ill mark this as solved.

[RuralGuy]

Great. It is a common problem and takes some getting used to before the concept sinks in.