Parameter error when opening form

[Accessible92866]

Hello all.

In Access 2003, I have a form that contains a subform which has two combo boxes. When the first one (Disciplines) is changed, the second one (Subdisciplines) is filtered (on key field DNumber) to show only the subdisciplines within that particular discipline. As a note, not all consultant companies will list a subdiscipline, so a null value is ok in the second combo box.

When I open the subform by itself, it works like a charm. However, when I open the main form, I get a parameter error which references the row source for the subdiscipline combo box (with the WHERE condition). When I click on either OK or Cancel in the error message box, it closes and my subform combo box 2 shows no rows.

How can I get rid of that parameter error? Do I need some kind of error handling? Is there a problem with the way the field on the subform is referenced somewhere?

I'm not a programmer, so any help will be hugely appreciated. Screen shots are attached.

Thanks!
Geekette in SoCal

 

[RuralGuy]

See it this link helps at all.

 

[Accessible92866]

Thank you, RG. That got me started in the right direction. I went into the row source for the second combo box (Subdisciplines) on the subform and used the Build button to let it build the name--and it worked. No errors now plus a populated drop-down list.

Slogging onward...

 

[RuralGuy]

Excellent! Glad I could help.