How to select 1 record en let it disappear in a list

[Jeroen]

Anybody can tell me how and if this is possible :

I have a table "products" where I put in records with Products.

In another form / table I use this products to assign to a part in the form.
How can i achieve that I only can use these products once in this form,
in other words : when I create a new record in this form, I should only see
NOT USED / SELECTED products to assign.

 

[mscertified]

Make the query that lists the products have a WHERE clause that filters out
those already used.

-Dorian

 

[John W. Vinson]

Anybody can tell me how and if this is possible :

I have a table "products" where I put in records with Products.

In another form / table I use this products to assign to a part in the form.
How can i achieve that I only can use these products once in this form,
in other words : when I create a new record in this form, I should only see
NOT USED / SELECTED products to assign.

Base the Combo Box on an "Unmatched Query Wizard", selecting only those
products that are *not* in the second table.

This might get a bit tricky - I presume that a given product might be
legitimately used in several different "orders" (or whatever you're creating),
just not twice in the same order. The unmatched query will need to reference
the form to determine if the product has been used in this order.

John W. Vinson [MVP]