Hiding selected items

[Andy Roberts]

I have a form with a combobox which lists all my products/services. Once I
have selected a product from the list I dont want to see it when I use the
combo box on another record. How do I achieve this? Also some of the items
listed in the combo box are services e.g. software training which is a
"product which can be assigned to many clients, whereas a particular PC for
example with a serial number can only be assigned once.

How do I achieve some of the items to not appear?

Regards

Andy Roberts

 

[Larry Linson]

I suspect I'd create a Field in the Products / Services Table to indicate
whether the item is Assigned, and set it to True when the item is assigned
and False when it is returned. You will also need some way to determine if
the Assigned field is applicable, such as a Category. Use a Criteria of
False on the Assigned Field in the Query you use as Row Source for the Combo
Box.

Larry Linson
Microsoft Access MVP

 

[Andy Roberts]

Thanks Larry

What would be better would be to somehow be able to set the assigned fiedl
to true when the item was picked from the combo box list. Is this possible
(bearing in mind the category issue)?

Andy