Forum Discussion

CletusK's avatar
CletusK
Copper Contributor
May 16, 2023

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...
C
Kasenga
CletusK's avatar
CletusK
Copper Contributor
May 18, 2023

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_Hepworth's avatar
George_Hepworth
Silver Contributor
May 18, 2023

CletusK 

 

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."

  • CletusK's avatar
    CletusK
    Copper Contributor
    May 22, 2023

    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_Hepworth 

    • George_Hepworth's avatar
      George_Hepworth
      Silver Contributor
      May 23, 2023
      That'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?
      • CletusK's avatar
        CletusK
        Copper Contributor
        May 23, 2023

        Thank you for your firm commitment to help me out.
        As I said, I am getting the results depending on whether I select 'Yes' or 'No' after applying a query.
        But my interest is on how, possibly, you get the values directly on a form when you click on the check box with/without filtering the Yes or No values with a query. As in the example I gave in my first question, say you have;
        Item one: $100
        Item two: $50
        Item three: $25
        Total: $175
        Assuming all the values are set to Yes or no, how if I uncheck one Item do I get the total reduced directly on the form, nd when unchecked the item still appears on the form but only its value is not applied in the total? Is there some coding involved behind this work around?
        I hope, may be, I have asked clearly now.

Resources