Hi,
I know this should be easy, but I am going wrong somewhere. I have a form frmStockTake and a subform sfrmStockTake. I have several combo boxes on the main form that the user selects to filter the subform via a query. This is working as I want.
My problem is I would like to ad preferably a toggle button to the main form. to show/hide stock with a qty = 0.
1. I tried a and additional combo box on the main form, but it returned any stock with a 0 in the quantity. (Row source = "0"). Not sure how to return just 0. I'd be happy with using this at this stage.
2. Any attempt on buttons on the main form either don't work or I get errors.
3. My subform is viewed as a datasheet from the main. If I change it to form view I have had some success showing qty = 0
But this is no good with wanting ta datasheet view.
Any help would be appreciated. Thanks in advance,
Poco
I know this should be easy, but I am going wrong somewhere. I have a form frmStockTake and a subform sfrmStockTake. I have several combo boxes on the main form that the user selects to filter the subform via a query. This is working as I want.
My problem is I would like to ad preferably a toggle button to the main form. to show/hide stock with a qty = 0.
1. I tried a and additional combo box on the main form, but it returned any stock with a 0 in the quantity. (Row source = "0"). Not sure how to return just 0. I'd be happy with using this at this stage.
2. Any attempt on buttons on the main form either don't work or I get errors.
3. My subform is viewed as a datasheet from the main. If I change it to form view I have had some success showing qty = 0
Code:
If me.filter = "[Qty] = 0" Then
me.filteron = True
else
me.filteron =False
End if
Any help would be appreciated. Thanks in advance,
Poco