I have data where I have multiple orders per creditor with amounts to be paid.
I created a continuous form which groups the orders by creditors names and shows the sum of the total amount to be paid.
I then want to add a toggle button per row which when clicked will mark all the orders for that creditor (that creditor row) as 'true' to be paid. (THIS I AM UNABLE TO DO)
So, my question is: How do I bind a toggle button to a row when the rows are produced by an aggregate query in a continuous form for MS Access?
I hope someone has a solution for me?
Thanks