I have VB 6.5, so hopefully this is the correct forum. If not please tell me which one is better to join.
I have a report with some VB code that executes on load. Basically it assigns values to two text boxes that act as "sums" (week1 and week2) on hours worked during the week dependent upon numbers/codes in each day box. So I have two weeks worth of hours and codes (14 boxes) and calculations for week1 and week2 populate the wk1 and wk2 textboxes. These 16 box rows repeat from the detail section on load.
The problem is the formula is only working on the last row. So the two sums (not straight sums but calculated formulae off the 14 numbers and codes) from the last row, repeat themselves for all the other rows as well. How can I do this a better way?