Cascading Combo Box Behaviour

[Turbojohn]

Hi,

I am using a form with 3 combo boxes name, weight and grade. The combo boxes are cascading:

A name is selected in the first combo box, since each name has different weights attached to it only the weights associated with that name are selected when the weight combo box is clicked. In a similar vein, there are only certian grades associated with a certain weight.

The effect is to filter the results so that an invalid entry cannot occur.

My problem is that once an entry is made and I select a new name for the next entry, the weight and grade boxes remain with the same values instead of updating to new values. Updating of the boxes does not appear to be working.

Does anyone have any ideas how to solve this problem?

Many Thanks
Turbojohn

 

[KenHigg]

Have you done a search in the forum for cascading combo boxes? There are some great examples available.

 

[Michael J Ross]

You need to requery the other combos following the change in Name using the After Update Event of the Name combo.

See http://office.microsoft.com/en-gb/as...730581033.aspx