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...
 

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

Main Control References SubForm Control 2
Recalculate fields in subform from Main form 2
Access Sub form opens before the main form in MS Access 0
calculated control event order 2
Calculated control event order 2
Disable buttons while "calculating..." 4
Calculation field on a main form displays Error 3
Form Subform Issue 2

Back
Top