It would like to know reason...

  • Thread starter Thread starter an
  • Start date Start date
A

an

I have F_Perc, SubF_Troc and SubSubF_Projects.
On SubForm I have a TextBox with:

Control Source
=[SubSubControlProjects].[Form]![SumValueEstimProjects]
(Where return value of the TextBox in FormFooter of the
SubSubF_Projects)

and named
TxtValueTotalEstimTroc

Work fine.

Now, similary, I would like to sum TxtValueTotalEstimTroc
in Form Footer of the SubForm.

With:
=Sum([SubControlTroc].[Form]![TxtValueTotalEstimTroc])
or
=Sum([SubF_Troc].[Form]![TxtValueTotalEstimTroc])

return error message #Error in TextBox.

I don't know why.
I need your help, please.

Thanks in advance.
an
 
What type of field is TxtValueTotalEstimTroc? If it is not numeric, then
you can't use "sum".

You would need to sum the "value" of the field if it is a text field.

Rick B
 
Thanks for your reply.

The field is Numeric type.
Format: Euro
Decimal Places: 2

an
-----Original Message-----
What type of field is TxtValueTotalEstimTroc? If it is not numeric, then
you can't use "sum".

You would need to sum the "value" of the field if it is a text field.

Rick B


I have F_Perc, SubF_Troc and SubSubF_Projects.
On SubForm I have a TextBox with:

Control Source
=[SubSubControlProjects].[Form]![SumValueEstimProjects]
(Where return value of the TextBox in FormFooter of the
SubSubF_Projects)

and named
TxtValueTotalEstimTroc

Work fine.

Now, similary, I would like to sum TxtValueTotalEstimTroc
in Form Footer of the SubForm.

With:
=Sum([SubControlTroc].[Form]![TxtValueTotalEstimTroc])
or
=Sum([SubF_Troc].[Form]![TxtValueTotalEstimTroc])

return error message #Error in TextBox.

I don't know why.
I need your help, please.

Thanks in advance.
an
Click to expand...


.
Click to expand...
 
Back
Top