Select "All" from one combo box show all records in other combo box.

[hasanrazaj1]

Hey All Dears.

i am wondering for several hours to reading threads and searching about this problem but i can't fix it till yet.

I have a form1 containing two combo boxes. cboCategory and cboProduct.
both combo boxes are unbound.

cboCategory RowSource property is as under:
SELECT Categories.CategoryID, Categories.CategoryName FROM Categories;



and after update event of cboCategory requery the second cboProduct.

while cboProduct RowSource Property is as under:
SELECT Products.ProductID, Products.CategoryID, Products.ProductName
FROM Products
WHERE (((Products.CategoryID)=[Forms]![Form1]![Combo0]))
ORDER BY Products.ProductName;

both work correct. now i want to add word "All" in first cboCategory and when i select "All" beside any Category name then it populate the second combo box cboProduct with All Records.

can it is possible.

i try to use a union query to add "All" in first combo box and it works good. but when i select "All" from first combo box it not update the second cbobox and not show all records which are not limit by categoryID.

any ideas, suggestions about this problem......

[slave138]

I would set the value for "All" to a null in the Category combo. In the Product combo, set the query criteria to something like:

WHERE (((Products.CategoryID)=[Forms]![Form1]![cboCategory]) OR [Forms]![Form1]![cboCategory] Is Null)

[slave138]

And make sure you requery the Products combo in the OnChange event of the Category combo.

[hasanrazaj1]

thanks slave 138 it is working good. when i select "All" from first combo then second pupolate with all records of products.

[slave138]

Happy to help