Hello,
I have a form frmOrders like the one in NW and I also have a subform, subOrdersSubform with the products information, like cboProuduct, Unit Price Quantity etc. I added another field cbocategory which is also a combo box and I want to make the cbocategory filter the products.
I created a query in which the subform is based on and I would like to know exactly what I need to do for the synchronization to function. I would like for the cboproducts to function regardless if something in the cbocategory is selected.
Would someone please give some detail instructions on how to do this.
Thank you in advance To guess is cheap
To guess wrongly is expensive
Tell me, I may remember
But involve me and I'll understand.
I have a form frmOrders like the one in NW and I also have a subform, subOrdersSubform with the products information, like cboProuduct, Unit Price Quantity etc. I added another field cbocategory which is also a combo box and I want to make the cbocategory filter the products.
I created a query in which the subform is based on and I would like to know exactly what I need to do for the synchronization to function. I would like for the cboproducts to function regardless if something in the cbocategory is selected.
Would someone please give some detail instructions on how to do this.
Thank you in advance To guess is cheap
To guess wrongly is expensive
Tell me, I may remember
But involve me and I'll understand.