combobox problem

[referee]

Hi, on a form i have 5 comboboxes with names in it from the same table
for example

in all the comboboxes the data is

A
B
C
D
E

now when i select from combobox 1 the letter A
in the other 4 comboboxes may the letter A not anymore availible
etc...

can someone help me with this code or query??

Thanks

 

[John Big Booty]

This is a variation on the theme of Cascading Combo boxes. Once you understand how they work, you will be able to apply that knowledge to restricting the selections available in your other Combo Boxes.