Prevent multiple combobox from picking the same options

[scopes456]

Good Day, I have 3 combobox of a main form. ( cbm1,cbm2,cbm3). All three combobox get their data from the same table (tbl1).

What i would like to accomplish after selecting an item in cmb1, when i go to cmb2 i cannot select the same item that i did in cmb1 ( i do not want it to show on the list),
The same will apply when i go to cbm3, i would not be able to pick what was in cmb1 and cbm2

Many thanks

 

[pbaldy]

Sounds like you may have a design issue, but you can use a modified version of cascading combos:

http://www.baldyweb.com/CascadingCombo.htm

In your case, the WHERE clause would exclude what was in previous combos. But I'd be thinking about the design first.