simple question...

[bbznyc]

I currently have a subform in the main form which is connected to a quiery. The quiery has [InitialBalance], [Payment] and [Total]. Everything works out great, i enter the Initial balance, enter payment or prepayment, and i get the total (e.g. 280-180=100). The problem is i need this to happen and i am in the clouds with VBA. Sometimes there are few payments made. So i want the [Payment] field to automatically erase when the value is entered and the [total] to update as well. In addition, I want there to be a counter to automatically tell me how many payments were made and as soon as the [total] is zero - the check box paid comes on.


Thanks for all suggestions

 

[aleb]

Try this. See attached file

 

[bbznyc]

sweet...

i will let you know how it works out...

 

[bbznyc]

from one problem to the next

I did everything fine...

Now i have the form in which i have 3 subforms. 2 subforms run quieries and the 3rd does summation and posts total on the table. All nice and pretty. However, when i close the db and reopen it, the information is gone from the main form, i am back to record "0" (but i can retrieve all the info from the table).

please let me know what could have