R
Robert
I'm working on an Access 2002 database with a form
listing payments made by students in schools. There is a
main form with the school name and a subform on the
mainform listing the students and payments. The subform
lists one student at a time. Below the list of payments
is a "Balance" textbox that is supposed to add the
payments made and subtract that figure from 100.
The balance works okay if there is only one student
listed for each school. However, if I add more students,
the balance is the same for all of them regardless of
what payments were made. The balance doesn't figure for
each individual student. It figures correctly for the
first student in each school, but not the others. What
am I doing wrong?
listing payments made by students in schools. There is a
main form with the school name and a subform on the
mainform listing the students and payments. The subform
lists one student at a time. Below the list of payments
is a "Balance" textbox that is supposed to add the
payments made and subtract that figure from 100.
The balance works okay if there is only one student
listed for each school. However, if I add more students,
the balance is the same for all of them regardless of
what payments were made. The balance doesn't figure for
each individual student. It figures correctly for the
first student in each school, but not the others. What
am I doing wrong?