Sub form calculations not correct on main form

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?
 
J

Jeff Boyce

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
 
G

Guest

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

Access Sub form opens before the main form in MS Access 0
Access Main form/Subform Navigation 0
Controlling a Sub Form 4
Requery main form after subform update and not lose place in main form. 1
referring to Subform Total in main form 1
go to specific record based on choice in subform 2
Main Form Record Loss 5
Sub-Form 1

Top