#Error on calculated control in a form

[Sarai]

Hi there.

I created a form to visualise a crosstab query with data referring to
several categories along 12 months, and then did a sum for each month without
ptoblems.

This year, I did a new crosstab query and then copied the form and simply
'redirected' it to this year's crosstab query. The idea was to change the
data, but keep the exact graphic image of the form. I do that often without
ever having had problems.

This time however, the sums give the #Error message.


I've checked that all the control names are correct, and the form is as
basic as it can get =Sum([Janeiro]). What is wrong? If the sums work in the
previous form, why don't they work on the 'copied' form?

 

[Maurice]

just a wild guess but the field [janeiro] does exist in the source?

 

[Sarai]

Well, the source is the numbers relating to that month in all the
categories. Those numbers show up fine.

For instance, I've got category 1 with values for every month, category 2
with values for every month and so on. The control's name is January in both
the original 2008 Form and the copied 2009 Form. The formula =Sum([Janeiro])
works in the original but not the copy.

There was an error =Name? for the Category 1 Total, Category 2 Total, etc,
at first. But that data was in the query, and I figured out the problem was
that the control wasn't directing to the source. So I just went to the
expression builder and opened the little folder for the query I needed and
chose the control I needed for the source.

I originally thought that maybe the January ( and the other months')
controls weren't directed to the right query, but the figures in the form are
the ones in the query, so that can't be the problem, can it?

I hope I'm explaining my problem clearly, and understanding your indications.

--
Sarai

just a wild guess but the field [janeiro] does exist in the source?
--
Maurice Ausum

Hi there.

I created a form to visualise a crosstab query with data referring to
several categories along 12 months, and then did a sum for each month without
ptoblems.

This year, I did a new crosstab query and then copied the form and simply
'redirected' it to this year's crosstab query. The idea was to change the
data, but keep the exact graphic image of the form. I do that often without
ever having had problems.

This time however, the sums give the #Error message.


I've checked that all the control names are correct, and the form is as
basic as it can get =Sum([Janeiro]). What is wrong? If the sums work in the
previous form, why don't they work on the 'copied' form?