Let me get straight to the point. I have a table containing the following fields:
ItemId (Autonumber)
ItemDescription (Text)
Discontinued (Yes/No)
As you might have guessed, the discontinued field is just a field that determines whether this particular item can still be used. So, in a form, I have one combo box with the following as it's Row Source:
Now my problem is this. When I tick Discontinued for some items, previous records with the combo box pointing to those items will be displaying blank since the item is not on the Row Source anymore. Is there any way to still display the item in the combo box even though the item is not in the row source anymore. Or, is there any other way to do this? Basically, the task I'm trying to accomplish is to cut the combo box choices so that only the current usable items are displayed but at the same time preserve old records with items that may have been discontinued.
Hope that makes sense. Thanks.
2B||!2B
ItemId (Autonumber)
ItemDescription (Text)
Discontinued (Yes/No)
As you might have guessed, the discontinued field is just a field that determines whether this particular item can still be used. So, in a form, I have one combo box with the following as it's Row Source:
Code:
SELECT tblItems.ItemId, tblItems.ItemDescription, tblItems.ItemDiscontinued FROM tblItems
WHERE (((tblItems.Discontinued)=False)) OR (((tblItems.Discontinued) Is Null));
Hope that makes sense. Thanks.
2B||!2B