Sum results from Query

M

Mountainman

I am constructing an order entry form consisting of:
-Customer information (record source orders table)
-Subform Order details (record source order details query..one id many
orders...)
and Subform Shipping details.
The record shipping details is based on a record source of a summation query
(same tabels as order details) which add all the weights of the individual
items per order(once run "UnitWeight" becomes"SumofUnitWeight") The problem
is once the order details subform is populated I need the shipping details
subform to instantly give a weight total (show"SumofUnitWeight); however I do
not get this total until one exits/enters the form. Any ideas?
Also, this form is getting too busy with subforms (main form for order I.D.,
subform for itemized order info, subform to show total weight query along
with total unit price). Now after getting total weight and unit price, I need
to get those units into another query to finish calculating total price
(enter estimated shipping costs, tax rate lookup, and sum all together). Any
ideas to simplify this?
 
J

Jeff Boyce

If your forms are doing calculations in unbound controls, you might need to
use Me.Repaint...

How does Access know to recalculate (and redisplay) the SumOfUnitWeight?
Are you using code in an AfterUpdate event to do the recalculation?

If you are basing your calculation on the existence of rows, but you haven't
yet saved a row-on-screen, how will Access know to add in the new (but not
saved) value?

Just some guesses...

Jeff Boyce
<Access MVP>
 

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

Top