Cascading Combo Boxes in a subform

[vangogh228]

I have a form (based on a table) named ClientData which contains a subform (based on a table) named ClientServices. In the subform, I have a combo control box called Department and one called Services. I have set the combo boxes so that the Services shown are dependent on the Department chosen.

It works fine when I go directly to the subform and test the operation, but when I try it within the subform IN the main form, I get a parameter dialog box error: As I make an entry from the dropdown of the Department field, the dalog box comes up, asking for "Forms!ClientServices" above the dialog's text box.

My After Update code in the Department field is

"Private Sub Department_AfterUpdate()
Me.[Services].Requery
End Sub

Is the problem the fact that I have the cascading combos in a subform instead of in a main form?

I really would like this to work. Help? THANKS!!

 

[naygl]

I think it's because you didn't refer to the subform correctly somewhere. You need to refer to it's parent form as well as the subform: Forms!ClientData!ClientServices

 

[vangogh228]

Thank you SO much!! Changed... implemented... operational!!!

12:17am here and enough of a triumph to let me turn this thing off and go to bed!!

Thanks again!!

Tom