not show a value already choose in one of the other ComboBoxes?

[cuok]

Hi

I will thank for any help with this:

I have three comboBoxes with same values (from same table)

Do you know any way or idea to not show a value already choose in one of the other ComboBoxes?

Thanks in advance
CUOK

 

[Darrylles]

Hi,

Only way that I can think is to change the combo rowsource query for each combo. So each combo rowsource would have something like:

Combo1:
SELECT myfield FROM mytable WHERE myfield <> forms!myform!mycombo2.value AND myfield <> forms!myform!mycombo3.value

Combo2:
SELECT myfield FROM mytable WHERE myfield <> forms!myform!mycombo1.value AND myfield <> forms!myform!mycombo3.value

Combo3:
SELECT myfield FROM mytable WHERE myfield <> forms!myform!mycombo1.value AND myfield <> forms!myform!mycombo2.value

And when any combo is clicked - requery the others.

Just out of interest, why do you have 3 combos to one table? You can multiselect in one combo.

Regards,

Darrylle &quot;Never argue with an idiot, he'll bring you down to his level - then beat you with experience.&quot; darrylles@totalise.co.uk

 

[cuok]

Thank you very much and Good morning Darrylle (now 07:00),

In my project I have ListBox, the first 3 items of this ListBox must fill first 3 different fields the other goes to memo field, those 3 fields must be filled first before any items goes to the memo field.
The rowsource of the 4 boxes is the same.

The idea you suggested looks good enough for me but I’m still thinking about way that &quot;deletes&quot; the item choose in combobox from the list box in this record but shall appear in record there it not choose.
I hope I made things more clear.

I’ll be more than glade if you have any idea how to complete this mission (as always you have!)

Thanks again
CUOK

 

[cuok]

Darrylle ,

I have to went now for about 6 hours so i can't see if you answered me till i come back.

CUOK