SUM function inside textbox on the bottom of the form return #Error (1 Viewer)

[amorosik]

I have a continuous form created with Access In the record origin there is a query that connects ACCOUNTINGMOVEMENTSTES with ACCOUNTINGMOVEMENTSROW and returns as many rows as there are accounting movement lines included in the current selection
Type recordset of the Snapshot form but I also tried Dynaset

In the body of the form all the requested lines are correctly displayed, for each line there are some fields taken from the ACCOUNTINGMOVEMENTSTES table and then some fields taken from ACCOUNTINGMOVEMENTSROW , one of these is the TAXABLE field, name of textbox is txtTaxable

A txtTotTaxable textbox in inserted in the bottom of the form, and in the control source there is a formula =Sum([TAXABLE ])

When I start the form the txtTotTaxable textbox continues to display #Error, what could it depend on?

I'm comparing it with a similar form, DocTes and DocRow, which works exactly as expected, they seem identical apart from the tables from which they draw the data, but Documents works and Accounting doesn't want to know about it

 

[arnelgp]

maybe use DSum() as controlsource of your textbox:

=Val(DSum("Taxable","querySourceOfYourForm") & "")

 

[amorosik]

maybe use DSum() as controlsource of your textbox:

=Val(DSum("Taxable","querySourceOfYourForm") & "")

Thanks for the suggestion
But I've already tried =Val(Dsum([TAXABLE];filter)&"")
Same #Error result in txtTotTaxable
What I really don't understand is why it works on the Documents form and it doesn't work on the Accounting form, and they are practically the same, except for table and filed name

 

[arnelgp]

is Taxable column, calculated column?

 

[CJ_London]

is the data type for your Taxable field numeric or text?

 

[ebs17]

=Sum([TAXABLE ])

Is the space necessary or a special feature?

 

[amorosik]

is Taxable column, calculated column?

No, TAXABLE is the name of a db field, from query

 

[amorosik]

is the data type for your Taxable field numeric or text?

Numeric

 

[amorosik]

Is the space necessary or a special feature?

Mistake, i have hand write the row