It would like to know reason...

[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

 

[Rick B]

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

 

[an]

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

.