Has anyone figured this out...MS Can't

  • Thread starter Thread starter DazedConfused
  • Start date Start date
D

DazedConfused

Please, Please Help. I am at wits end.

Name of MainForm [FrmServiceOrder] and calculated txtbox [TS2].

In my Main Form [FrmServiceOrder] I have a Text Box [TS2] I am trying to
bring the total Amount from the PartsUsedSubForm [TS1] to and display a
Total.
It's Not working.. I get the #Error? message.


Name of SubForm [PartsUsedsubForm] and calculated txtbox [TS1].

Calculated Text field in Form Footer section named TS1 set to currency.
The calculation in the source property is =[QUANTITY]*[UNITPRICE] which
are both currency fields.



I there anyone that can explain How this is supposed to work, and
can actually get it to work. I noticed Microsoft has problems
making this work in one of their Sample Forms Database.
They also display the #Error?

Can you Please explain how I should do this?



Thank You
 
Check the [Orders Form] / [Orders Subform] combination in the sample
database "NorthWind" that comes with your Access software. IIRC, there is
an "Extended Total" that is carried from the Subform to the MainForm.

One thing to note is that the name of the Subform*Control* (which you need
for the expression) may be different from the name of the Form being used as
the Subform (more accurately, being used as the SourceObject of the
SubformControl.
 
Van
Thanks very much
After systematically listing each Form, Calculating field and Control Source
It finally worked.
Thanks again

Van T. Dinh said:
Check the [Orders Form] / [Orders Subform] combination in the sample
database "NorthWind" that comes with your Access software. IIRC, there is
an "Extended Total" that is carried from the Subform to the MainForm.

One thing to note is that the name of the Subform*Control* (which you need
for the expression) may be different from the name of the Form being used as
the Subform (more accurately, being used as the SourceObject of the
SubformControl.

--
HTH
Van T. Dinh
MVP (Access)




DazedConfused said:
Please, Please Help. I am at wits end.

Name of MainForm [FrmServiceOrder] and calculated txtbox [TS2].

In my Main Form [FrmServiceOrder] I have a Text Box [TS2] I am trying to
bring the total Amount from the PartsUsedSubForm [TS1] to and display a
Total.
It's Not working.. I get the #Error? message.


Name of SubForm [PartsUsedsubForm] and calculated txtbox [TS1].

Calculated Text field in Form Footer section named TS1 set to currency.
The calculation in the source property is =[QUANTITY]*[UNITPRICE] which
are both currency fields.



I there anyone that can explain How this is supposed to work, and
can actually get it to work. I noticed Microsoft has problems
making this work in one of their Sample Forms Database.
They also display the #Error?

Can you Please explain how I should do this?



Thank You
Click to expand...
Click to expand...
 
Back
Top