Sub form calculations not correct on main form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sub form calculating a few numbers. I have a text box on the main
form referencing the subform control with the sum of the numbers. The main
form control does not show the last entry. If I have three rows to calculate
it shows the value of the first two rows. It does not include the last
record in the calculation.


Can anyone shed any light?
 
Consider posting the SQL statement you are using to get the sum of the
subform data into the main form control.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thank you. I will try it.
--
Dar


Jeff Boyce said:
Consider posting the SQL statement you are using to get the sum of the
subform data into the main form control.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
Back
Top