Reducing combo box selection possibilities

[bbig80524]

I would like to remove or hide, or in some way identify, an item in a combo
box once it has been selected. Items in this combo box can only be used once
so to avoid confusion I like to either hide the item or highlight it to let
the user know it has already been used. I have envoked a control that
prevents duplication but it would be a further enhancement to either remove
it or indicate it has already been used.

The item/record must remain in the supplying table.

 

[John Vinson]

I would like to remove or hide, or in some way identify, an item in a combo
box once it has been selected. Items in this combo box can only be used once
so to avoid confusion I like to either hide the item or highlight it to let
the user know it has already been used. I have envoked a control that
prevents duplication but it would be a further enhancement to either remove
it or indicate it has already been used.

The item/record must remain in the supplying table.

You can base the Combo Box on a "frustrated outer join" query. Let's
say that you're picking items from tblSource and storing them in
tblTarget. In order to present only those items in tblSource which
have NOT yet been selected into tblTarget, create a Query like:

SELECT <fields>
FROM tblSource LEFT JOIN tblTarget
ON tblSource.fieldname = tblTarget.fieldname
WHERE tblTarget.fieldname IS NULL
ORDER BY <fields>;

where fieldname is the combo's bound column field.

John W. Vinson[MVP]
(no longer chatting for now)