checkbox help

[Guest]

I'm new here so I'll try to explain as well as possible.

I'm making a database for my class. It calculates the payments due on a
weekly basis for multiple bowling leagues based on the league itself. I have
the majority of the information finished and calculated except for a couple.

My problem is that I want to use 2 check boxes that will each take 2 values
from text boxes [SecFee] and [Sponsorship] off of a separate form [frmLeague]
and use that in a calculation to find out how much the bowler owes Total and
how much they have paid. I want it to work where if the check box is
activated then it adds the contents of the text box to the total amount paid.
If necessary I can supply the database for help. If you need any more
explaining let me know.

Thanks,
Nick

 

[John]

Why are you taking the data from a different form. Why don't you make the
calculations on the form where the data is being entered.

John

 

[MacDermott]

Well, you haven't really asked a question, so I'll just contribute a few
thoughts:
1. Values aren't generally stored in forms; they're stored in tables,
which may be bound to forms. You can retrieve data from underlying tables
even when the form is closed.
2. Checkboxes generally have an OnClick event procedure, which fires
when the checkbox is clicked (this normally toggles between On and Off as
well), and gives you a place to write code.

HTH