refreshing a combo box

[Lauren B]

I have a combo box on a form that contains vendor names. I then have a
second combo box that contains products offered by that particular vendor.
The first combo box dictates what appears in the second combo box via a
query.

When the user selects a vendor in the first combo box, the second one is
populated correctly. However, if the user then selects a different vendor
in the first combo box, the products from their first selection still remain
in the second one. What code do I need to use to have the second combo box
refresh as a result of any changes made in the first one.

Thank you for any assistance.

LB

 

[Ken Snell [MVP]]

If you've tied the two combo boxes together in the "normal" way, this should
occur automatically, as the first combo box's AfterUpdate event would run
code to requery the second combo box's Row Source.

So, tell us how you set up the two combo boxes.