20 combo box with one table

[compaq2003]

hi
iam using Access 2002
i am using one table and 20 combo box using same table
what i want,, when i use one name from the table in one combo box the selected name must be removed from the other combo box autmoticaly

thank you

 

[Aqif]

Hi

Use this code on After Update event of ur comobo box

Me.ComboBox2.RowSource="Table/Query"
Me.ComboBox2.RowSource="Select MyField From MyTable Where MyField Not Like '" & Forms!MyForm!ComboBox1 & "';"
Me.ComboBox2.Requery

Note : I am assuming that ur combo box has got Text type data in it

Cheers!
ÙÇãá

 

[compaq2003]

thank you
i am new on Access
can you explain to me how to put the codes on details
thank you again