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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unremovable horizontal scroll bar on subform 1
Main Form and two Subforms 2
Pause Subform 1
After Update event does not fire when pasting multiple rows intosubform datasheet view 1
Reference control in subform 10
Using value from calculated field 7
Commit a Row in a Subform 0
Retrieve a value from an unbound control on a subform 4

Back
Top