subform values

  • Thread starter Thread starter AC
  • Start date Start date
A

AC

I have a main form with a subform and wish to calculate a value in each row
of the subform based on the values in each row of the subform. When doing
this the calculation always uses the value in the first row, how do I get it
to cycle through the rows using the values in each row.
 
It's not that it always uses the first row, it should be that is uses the
value of the current row. To work around this, do the calculation in the
query feeding the subform and bind that textbox to the calculated field.
 
I had a similar problem and discovered that I could access all of the rows
when my sub form was located in the detail section of the main form. That may
help.
 
Back
Top