Solved Multie Cascading combo box based on set values

[crazy_ivan_1]

Hi,

I'm trying to create a rating system of sorts.

I have 5 fields with a combo lookup. Each lookup has values 1-5

I am trying to get the comboboxes to update based on the values of the other fields.

E.g.

Cmb1 has number 4 selected
So cmb2 to cmb5 will only show numbers 1,2,3 and 5
Then cmb2 has number 2 selected
So cmb 3 to cmb5 will only shows numbers 1,3,5

And so on.

I'm guessing that I need an after update of cmb1 I would need a requery of the values to eliminate the selected value, but I can't figure out how to do it.

Any suggestions or help would be most appreciated.

Thanks

 

[Gasman]

I would look at deleting the entry in the rest of the combos when selected in the afterupdate event as you mention.
As you would know the order, you could just delete that entry, rather than walking through the items.?

ComboBox.RemoveItem method (Access)

Office VBA reference topic

docs.microsoft.com

 

[arnelgp]

the combos are based on a table tbl_rating.
see the demo.

 

[crazy_ivan_1]

the combos are based on a table tbl_rating.
see the demo.

Wow...that works perfectly.

Thanks

I was having a look at your code.

If I wanted to do an additional set of comboboxes unrelated to the first, would I need to recreate the public function with the alternate combobox names?