unique comboboxes

[ben1988]

hi :)

i have more than 10 comboboxes with same query source
how can i control value selection
so if any value selected in any combo, the user cant select this value in other combo

(again i have more than 10 combo)

thanks

[Seth Schrock]

There are two ways to do this. You can either change the row source to filter out selections based on the other combo boxes, or you can do this in VBA and check in the Before_Update event of each combo box to see if the new value is selected in any of the other combo boxes and cancel the event it if is.

[zmbd]

See if this article fits the bill:
home > topics > microsoft access / vba > insights > cascading combo/list boxes