How do I link unbound combo boxes in a subform

[Guest]

I have several subforms in which I have linked two unbound combo boxes so
that the selection of the first combo box filters the rows which are selected
in the second combo box. Example: Category combo box filters SubCategory
combo box. The subforms are then embeded as tabbed pages in a Main form.
Seems to work just fine when I look at the subforms individually but when I
open the Main form I get requests to manually enter parameter values. I
suspect the VB Form_Open subroutine is trying to apply itself to the Main
form which doesn't contain the combo boxes. Any sense what is going on here
or how to get around it. Any ideas would be much appreciated. Thanks!

 

[Guest]

I take that the combo values change the filter property of the subforms.

Try setting the 'on lostfocus' property of the comboboxes, to repaint the
subforms

Hope this works.
Good Luck!