Limit Combo Box List

[kcmark]

I have a form where a user has to select 3 unique items (from a list of about 12 items). I am using 3 combo boxes to capture the 3 selections. I can get the drop-down list to populate correctly from a query I built. However, I would like to limit the list to only the items that have not been selected. In other words, once a user selects an item it is no longer available as an option for the other 2 combo boxes. Any ideas on how to accomplish this?

 

[kcmark]

I added this code to the row source line. SR1, SR2 and SR3 are the combo boxes used to capture the selection.

SELECT SRQ.Rep_Name FROM SRQ WHERE SRQ.Rep_Name<>SR2 And SRQ.Rep_Name<>SR3

The entire list is being populated to the combo list, but it is not getting updated when a selection is being made (the entire list shows for all 3 combo boxes).

 

[glalsop]

In the After_Update event of all three combo boxes, try requerying the other 2.

Soin the After_Update event of SR1, say:

Me.SR2.Requery
Me.SR3.Requery

Do the same for the other combo boxes.

The objective might be better accomplished using a multi-valued list box.

-Gary

 

[kcmark]

Works like a charm. Thanks!