Forum Discussion
UNCHECK BALANCE ITEM FROM A BILL
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."
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.
- 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?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.First, my apology for the slow response. This forum has to be the least usable forum around.
So, perhaps I didn't dig deep enough into the original problem. There are actually two different things going on it seems. One is the ability to check which items to include.
The other is the calculation on the form showing the total of the values for "checked" items. That's the part I overlooked.
How are you displaying that total on the form? Is it an expression in a control? Or, as I perhaps wrongly assumed, a calculation in the underlying query? If the former, there's one approach. If it's the latter, there is another approach that would work better.