>Naomi and Tamar:
> Todah Rabah! Since this is used in a parent class, I am hoping that the Combobox will notice on its own if its ListCount has changed. In the Requery method, I put
>This.Enabled = (This.ListCount > 1)
>
>I put a Debugger Breakpoint on the line. When I tested it by changing the Value in Combobox1, which changed the Value of Combobox2 (Combobox1's RowSource is the parent table of Combobox2's RowSource), neither one fired its Requery method.
>
>Any ideas on why it doesn't fire?
>
>Jerry
Unless some method of combo1 calls Requery of combo2 it is not going to fire automatically.
If it's not broken, fix it until it is.
My Blog