Solved Sum #Error in Form

[accessonly11]

hi guys i m facing this error on my order details subform. the fields (which sums i need on subform footer) are calculated fields

order details table design view

i need the sums of RetailPriceT and SalePriceT fields, which later i will refer on mainForm.Footer.Field


Design view of order details subform

subform footer controls with control source, text name is text457

main footer field control source

this is the normal view of mainform when it load, it is empty

...
if there is any old thread which sovle the same problem, then refer me please.

 

[arnelgp]

you upload your db again.

 

[accessonly11]

you upload your db again.

here it is

 

[arnelgp]

i created Query, qryTotals.
on each Total textbox on the Footer of the subform, i Dlookup() the value.

also your Order form is always Adding record (pencil on the record selector),
so i just set the Default value of the customerid combobox to (11).

 

[accessonly11]

that is the proper way.
but what if i want the values of gross total and net total on order form get stored on order table.

 

[arnelgp]

but what if i want the values of gross total and net total on order form get stored on order table.

not recommended, since you already has the Query.
think of it as you are saving it in another table (but actually it is a query).
the Query will always return correct value.