Combo Box problem

[jspe377522]

Hi

I would like to know if, and if so how, I can stop users picking options in a combo box is another combo box has the same option selected.

For instance: I have the first combo box cboMachines which is a simple machines list, there are 20 other comboboxes cboAccessoryID1 - 20. When a user picks a machine in cboMachines only the accessories for that machine type are available in the cboAccessory boxes. I have done this with VB. I want the users to pick say Accessory 1 in cboAccessory1 then either it not be available in cboAccessory2 or have an error message displayed if they try to select it.

I hope i have explained this enough.
Cheers
James

 

[FoxProProgrammer]

I'll be happy to look at your database. Please post your email address and I'll reply to it.

Thanks,

dz

 

[jspe377522]

JSpe377522@aol.com