Forum Discussion
CletusK
May 16, 2023Copper Contributor
UNCHECK BALANCE ITEM FROM A BILL
How can I uncheck or exclude an item from the bill balances and grey it out when I am not supposed to pay for it in MS Access? Eg the bill on the form lists items likethis: Fish $200 Rice $100 B...
George_Hepworth
May 18, 2023Silver Contributor
You'll need an additional field in the table. That field can be called something like "PayableByMe", or probably something more appropriate. You can make it a boolean, or Yes/No field.
In the form, check the control bound to this form to indicate the line item is payable by you, or uncheck it to indicate that it is not your responsibility to pay it.
In the control which calculates total payable, add a filter that only sums up records where this field is checked.
In the form, check the control bound to this form to indicate the line item is payable by you, or uncheck it to indicate that it is not your responsibility to pay it.
In the control which calculates total payable, add a filter that only sums up records where this field is checked.
CletusK
May 18, 2023Copper Contributor
Thanks a lot for your prompt response. I did as you advised and got the results by use of a query.
But is not there a way of doing it straight on a form, where you directly uncheck the item, and it still remains seen on the form, however unchecked, but the totals get adjusted?
I've seen a tutorial demo where such was done and the idea captivated me. I don't know if that would need some coding.
Thanking you in anticipation.
- George_HepworthMay 18, 2023Silver Contributor
I described that in my first post, but it was confusing the way it was written:
"In the form, check the control in the form which is bound to the field in the table to indicate the line item is payable by you, or uncheck it to indicate that it is not your responsibility to pay it."
- CletusKMay 22, 2023Copper Contributor
Thanks for your response. This is what I know I've even doing and the results work just fine. Only that the method of excluding one item is quite different from this procedure. Otherwise that's alright.
- George_HepworthMay 23, 2023Silver ContributorThat's a bit confusing to me. I know it's excluding one item at a time because each item is a record and the record has the Boolean field indicating that item is to be paid or not. Isn't that what you want? What do you mean by "this procedure", if not?
The totals query would be set up to sum only checked items, or items with "Yes" in that field. So, what is different?