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
 
does the calculated control [TS1] in the subform work?
post the calculation or statement you're using in the ControlSource property
of [TS2].
btw, please don't multi-post. if you feel you need to post to more than one
group, cross-post instead so everyone can see the posted replies.
 
For keeping it simple as possable I named the fields TSx

=[TS1].[Form]![TS2]

I have tried every concievable way and finally
figured to try and keep it as simple as I can.

Please explaind how I should cross-post questions to the group.
I will be glad to do so.

Thank You

tina said:
does the calculated control [TS1] in the subform work?
post the calculation or statement you're using in the ControlSource property
of [TS2].
btw, please don't multi-post. if you feel you need to post to more than one
group, cross-post instead so everyone can see the posted replies.


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...
 
to cross-post, just list the name of every newsgroup you want to post to,
when you initiate the post - rather than initiating a separate post for each
newsgroup.

hth


DazedConfused said:
For keeping it simple as possable I named the fields TSx

=[TS1].[Form]![TS2]

I have tried every concievable way and finally
figured to try and keep it as simple as I can.

Please explaind how I should cross-post questions to the group.
I will be glad to do so.

Thank You

tina said:
does the calculated control [TS1] in the subform work?
post the calculation or statement you're using in the ControlSource property
of [TS2].
btw, please don't multi-post. if you feel you need to post to more than one
group, cross-post instead so everyone can see the posted replies.


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...
Click to expand...
 
Back
Top