J
Joe Cilinceon
I have a table called Tenant Ledger which stores all payments for every
tenant in the database. Now I have a Query that takes the latest Paid Thru
date adds calculates the next Month Due amounts based on the Current Date.
I'm setting up a payment screen that will show the Unit #, Paid Thru Date,
Rent Owed, Fees Owed and Total on the Unit on each row in a Datasheet view.
Now a tenant may have more than 1 unit so the form will filter on the CustNo
from the main form. Well so far I've got it working with the following
exception:
Here is where the problem arrises as I want to have each Unit row start with
a Yes/No check box. This box when set to yes will be included in the totals
owed (all units checked) at the bottom of the form. No units will be
ignored. My real problem is the Check boxes themselves as I can't seem to
make them work at all. I can't seem to add a check box to the underlaying
query so I'm asking here if I will have to add a check box to the main table
which seems like a waste as this table will get pretty large over time.
And for those interested, once paid it will post each unit to the ledger
with its own transaction number by dividing up the money paid, making it the
current paid thru date..
tenant in the database. Now I have a Query that takes the latest Paid Thru
date adds calculates the next Month Due amounts based on the Current Date.
I'm setting up a payment screen that will show the Unit #, Paid Thru Date,
Rent Owed, Fees Owed and Total on the Unit on each row in a Datasheet view.
Now a tenant may have more than 1 unit so the form will filter on the CustNo
from the main form. Well so far I've got it working with the following
exception:
Here is where the problem arrises as I want to have each Unit row start with
a Yes/No check box. This box when set to yes will be included in the totals
owed (all units checked) at the bottom of the form. No units will be
ignored. My real problem is the Check boxes themselves as I can't seem to
make them work at all. I can't seem to add a check box to the underlaying
query so I'm asking here if I will have to add a check box to the main table
which seems like a waste as this table will get pretty large over time.
And for those interested, once paid it will post each unit to the ledger
with its own transaction number by dividing up the money paid, making it the
current paid thru date..
