Need some help in VB coding (1 Viewer)

[alguzman]

I have a main form with a synchronized pop up form named Payments. On the main form I have a unbound text box that shows amount due. When I enter new payment info in the payment pop-up form for the first record for 100 dollars and the dues payment = 100 dollars the main form will show amount due 0 (good). For the next year and the second record for the same person I enter payment (in the pop-up form) 100 dollars and now the main form will show amount due Over (100) dollars. How can I have the code to read only the second record and ignore the first and so on for the next years.

 

[Travis]

Do you have an Amount Due Table?

What it looks like to me is that you are calculating the amount Due by a static $ 100.00, but are storing the amounts paid.

 

[alguzman]

Yes I'm saving the total amount paid on the main member table. I do not have a amount due table.

I wanted the total amount paid to be easily seen on the main form without using a pop-up cmd button or a subform.