Dependent combo box/list box not updating onChange

[jonman03]

Hi all,

I have a simple form with 1 combo box and 1 list box. I have the combo box with all manufacturing sites, and the combo box with products at those mfg sites. I have the dependent (list box) criteria set to the combo box.

I also have the combo box onChange event set to: Me.currentmfg.Requery

However, when I change the Mfg site, the products aren't updating in the list box right away. If I click to design view, then back to form view, it works perfectly.

Is there any way to get it to change/update right away? Without having to reload the form? I thought the onChange Requery would do this?

Thank you!

 

[vbaInet]

This might be what you need:

http://baldyweb.com/CascadingCombo.htm

 

[jonman03]

Thank you. That cleared it up.

I had it set up correctly, I just had the Requery code requerying the first combo box, instead of the 2nd (dependent) list box.

Thanks!

 

[vbaInet]

No worries. Thanks to pbaldy for having that example available on his site