Need Help with a drop box

[Richard Basmayor via AccessMonster.com]

I am working on a database with a drop down menu for item name. Theses
items are already apart of a large inventory. What I need to do is:

1: I need to be able to keep the items that are already linked to records
in the database intact

2: I need to remove some items form the list and make it so that when a
new record is made the drop down will only show the items that I want (but
still retain the items I don't want to show in the drop down)

I tired making a yes/no field called active that I could click and hide
some of the items in the field. The propblem with that is the old records
would show a blank in the item field because one of the hidden items was
not showing in the drop down

If anyone knows of a simple way to not show certain items in a drop down
box but retain the items you don't want to show for old records please help
me out

Thanks

 

[Penguin]

If your listbox is bound to a query that shows only active data
(meaning all yes records) then you should have no problem.