I am using a combo box that allows the user to select only from a list of current products (e.g. ice cream flavors) from the Products table. The Products table includes the fields “ProdName” and “ProdAvail”. The Row Source uses the following query:
SELECT [Products].ProdAbbr, [Products].ProdName, [Products].ProdAvail
FROM [Products]
WHERE ((([Products].ProdAvail)=-1))
ORDER BY [Prods].ProdName
This works fine. My problem is that when a product is no longer available, it does not show up in the box. That is, if I look at a customer’s past order, I can see that there are ‘x’ number of records (products) but only the current ones are showing.
The control is in a subform that is linked to another subform (date of order).
Any help to show the invisible products would be appreciated.
SELECT [Products].ProdAbbr, [Products].ProdName, [Products].ProdAvail
FROM [Products]
WHERE ((([Products].ProdAvail)=-1))
ORDER BY [Prods].ProdName
This works fine. My problem is that when a product is no longer available, it does not show up in the box. That is, if I look at a customer’s past order, I can see that there are ‘x’ number of records (products) but only the current ones are showing.
The control is in a subform that is linked to another subform (date of order).
Any help to show the invisible products would be appreciated.