I have a subform that has fields linked from the database (total project hours), a text field for user entry (hours used), and a field that displays a calculation (hours remaining). This subform is in a form so the subform can show multiple values. The problem is that when a user types in a value for hours used, the hours remaining changes to total hours - hours used, but for every row in the subform. Here's an example:
Subform opens to this:
Total hours Hours used Hours Left
1440 3 1437
140 102 1437
User changes a value:
Total hours Hours used Hours Left
1440 3 90
140 50 90
Does anyone know why this is happening?
Thank you,
Steve Geller
Subform opens to this:
Total hours Hours used Hours Left
1440 3 1437
140 102 1437
User changes a value:
Total hours Hours used Hours Left
1440 3 90
140 50 90
Does anyone know why this is happening?
Thank you,
Steve Geller
