#Error returned in sum control

[B Karthick]

Dear MVPs and Experts,

I have [Wt] Field and [Wt] Control on a form.
This form is a sub form in another Main Form.
In the footer of the Sub form, I have a calculated
control with source =Sum([Wt]). It was working
properly.

Suddenly, I want to add more fields to this subform.
I have made some addition to the table. I have never
changed the [Wt] field. Now when i changed the record
source of the subform to a query and back to table it
returns #Error.

I have even tried to change the format of the control to
General Number, but nothing seems to work.

Can you please guide me on what went wrong? Thanks
in anticipation.

Best Regards
B Karthick
Access Addict

 

[Ken Snell [MVP]]

Is the Wt control bound to the Wt field in the subform?

The #Error? that you're seeing would suggest that the subform does not think
there is a Wt field anymore, or that there are no records in the subform's
recordsource.

Give us more details about what you changed in the table and in the
subform's recordsource string.

 

[Larry Daugherty]

You left out a few details - such as whether the original Wt control
still receives the correct value. What does propagate to the
subform? Are the Link Master and Link Child fields pointing to two
fields with the same value, i.e. PK & FK?

HTH

 

[B Karthick]

Dear Ken Snell,

There are two controls

1. the 'Wt' control with the record source as [Wt] in the sub form which
does return the correct value
2. the 'txtSumWt' control in the footer with the record source as =Sum([Wt])

Yes! There are records returned in the Sub Form (continuous) correctly
displaying the various [Wt]
field values.

I have added another field in the Table called [Volume] whose source in the
sub form will be the
product of [Length]*[Breath]*[Height].

Earlier my intention was just to change to record source of the sub form to
a query. The query
will just have a additonal Field to calculate the Volume at Runtime. I
presume the #Error started
to come as soon as I changed the record source of the Form from Table to
Query.

Hope I have given the required details. Thanks.

Best Regards
B Karthick

Is the Wt control bound to the Wt field in the subform?

The #Error? that you're seeing would suggest that the subform does not
think there is a Wt field anymore, or that there are no records in the
subform's recordsource.

Give us more details about what you changed in the table and in the
subform's recordsource string.

--

Ken Snell
<MS ACCESS MVP>

Dear MVPs and Experts,

I have [Wt] Field and [Wt] Control on a form.
This form is a sub form in another Main Form.
In the footer of the Sub form, I have a calculated
control with source =Sum([Wt]). It was working
properly.

Suddenly, I want to add more fields to this subform.
I have made some addition to the table. I have never
changed the [Wt] field. Now when i changed the record
source of the subform to a query and back to table it
returns #Error.

I have even tried to change the format of the control to
General Number, but nothing seems to work.

Can you please guide me on what went wrong? Thanks
in anticipation.

Best Regards
B Karthick
Access Addict

 

[B Karthick]

Dear Larry,

Yes! the original Wt control in the sub form still received the correct
value. Yes
PK [AWB No] in the primary table [AWB] and FK [AWB No] in the foreign
table [Bill Details] are the same.

Also before making the addition of Field [Volume] to the Primary Table [AWB]
the sub form footer control 'txtSumWeight' returned the correct value.

Best Regards
B Karthick
Access Addict

You left out a few details - such as whether the original Wt control
still receives the correct value. What does propagate to the
subform? Are the Link Master and Link Child fields pointing to two
fields with the same value, i.e. PK & FK?

HTH
--
-Larry-
--

Dear MVPs and Experts,

I have [Wt] Field and [Wt] Control on a form.
This form is a sub form in another Main Form.
In the footer of the Sub form, I have a calculated
control with source =Sum([Wt]). It was working
properly.

Suddenly, I want to add more fields to this subform.
I have made some addition to the table. I have never
changed the [Wt] field. Now when i changed the record
source of the subform to a query and back to table it
returns #Error.

I have even tried to change the format of the control to
General Number, but nothing seems to work.

Can you please guide me on what went wrong? Thanks
in anticipation.

Best Regards
B Karthick
Access Addict

 

[Larry Daugherty]

I should have remarked before that it's a good idea to always name
fields and controls different from each other.

Just making the changes you reported wouldn't cause the problem. What
happens when you try using DSum() in the footer?

HTH
--
-Larry-
--

Dear Larry,

Yes! the original Wt control in the sub form still received the correct
value. Yes
PK [AWB No] in the primary table [AWB] and FK [AWB No] in the foreign
table [Bill Details] are the same.

Also before making the addition of Field [Volume] to the Primary Table [AWB]
the sub form footer control 'txtSumWeight' returned the correct value.

Best Regards
B Karthick
Access Addict

You left out a few details - such as whether the original Wt control
still receives the correct value. What does propagate to the
subform? Are the Link Master and Link Child fields pointing to two
fields with the same value, i.e. PK & FK?

HTH
--
-Larry-
--

Dear MVPs and Experts,

I have [Wt] Field and [Wt] Control on a form.
This form is a sub form in another Main Form.
In the footer of the Sub form, I have a calculated
control with source =Sum([Wt]). It was working
properly.

Suddenly, I want to add more fields to this subform.
I have made some addition to the table. I have never
changed the [Wt] field. Now when i changed the record
source of the subform to a query and back to table it
returns #Error.

I have even tried to change the format of the control to
General Number, but nothing seems to work.

Can you please guide me on what went wrong? Thanks
in anticipation.

Best Regards
B Karthick
Access Addict

 

[B Karthick]

Dear Larry,

Its ok! I will add txt to all the text box controls. I wil try to use the
DSum() in the
footer. Reverting ...

Thanks once again.

Best Regards
B Karthick
Access Addict

I should have remarked before that it's a good idea to always name
fields and controls different from each other.

Just making the changes you reported wouldn't cause the problem. What
happens when you try using DSum() in the footer?

HTH
--
-Larry-
--

Dear Larry,

Yes! the original Wt control in the sub form still received the correct
value. Yes
PK [AWB No] in the primary table [AWB] and FK [AWB No] in the foreign
table [Bill Details] are the same.

Also before making the addition of Field [Volume] to the Primary Table [AWB]
the sub form footer control 'txtSumWeight' returned the correct value.

Best Regards
B Karthick
Access Addict

You left out a few details - such as whether the original Wt control
still receives the correct value. What does propagate to the
subform? Are the Link Master and Link Child fields pointing to two
fields with the same value, i.e. PK & FK?

HTH
--
-Larry-
--

Dear MVPs and Experts,

I have [Wt] Field and [Wt] Control on a form.
This form is a sub form in another Main Form.
In the footer of the Sub form, I have a calculated
control with source =Sum([Wt]). It was working
properly.

Suddenly, I want to add more fields to this subform.
I have made some addition to the table. I have never
changed the [Wt] field. Now when i changed the record
source of the subform to a query and back to table it
returns #Error.

I have even tried to change the format of the control to
General Number, but nothing seems to work.

Can you please guide me on what went wrong? Thanks
in anticipation.

Best Regards
B Karthick
Access Addict

 

[B Karthick]

Dear Larry,


1)
I have replaced the control source with the following but still it does not
work.
=DSum([Wt],"Details","AWB No = " & [Forms]![AWB]![AWB No])

2)
Earlier I tried the following ...
=DSum([Wt],"Details",[AWB No])

It worked but it did not count the sum of [Wt] for only those records
displayed
in my sub form. Hence I have to mention the criteria as in 1) in order to
achive
the similar effect of Sum() function.

Can you please guide me on whether my Criteria in 1) was wrong? Or there
is something else to it?

Thanks for your help once again.

Best Regards
B Karthick
Access Addict

Dear Larry,

Its ok! I will add txt to all the text box controls. I wil try to use the
DSum() in the
footer. Reverting ...

Thanks once again.

Best Regards
B Karthick
Access Addict

I should have remarked before that it's a good idea to always name
fields and controls different from each other.

Just making the changes you reported wouldn't cause the problem. What
happens when you try using DSum() in the footer?

HTH
--
-Larry-
--

Dear Larry,

Yes! the original Wt control in the sub form still received the correct
value. Yes
PK [AWB No] in the primary table [AWB] and FK [AWB No] in the foreign
table [Bill Details] are the same.

Also before making the addition of Field [Volume] to the Primary Table [AWB]
the sub form footer control 'txtSumWeight' returned the correct value.

Best Regards
B Karthick
Access Addict

You left out a few details - such as whether the original Wt control
still receives the correct value. What does propagate to the
subform? Are the Link Master and Link Child fields pointing to two
fields with the same value, i.e. PK & FK?

HTH
--
-Larry-
--

Dear MVPs and Experts,

I have [Wt] Field and [Wt] Control on a form.
This form is a sub form in another Main Form.
In the footer of the Sub form, I have a calculated
control with source =Sum([Wt]). It was working
properly.

Suddenly, I want to add more fields to this subform.
I have made some addition to the table. I have never
changed the [Wt] field. Now when i changed the record
source of the subform to a query and back to table it
returns #Error.

I have even tried to change the format of the control to
General Number, but nothing seems to work.

Can you please guide me on what went wrong? Thanks
in anticipation.

Best Regards
B Karthick
Access Addict

 

[Ken Snell [MVP]]

Post the SQL statement of the query that you're now using as the subform's
recordsource. I still think that the #Error? is because the subform does not
"see" a Wt field.

--

Ken Snell
<MS ACCESS MVP>

Dear Ken Snell,

There are two controls

1. the 'Wt' control with the record source as [Wt] in the sub form which
does return the correct value
2. the 'txtSumWt' control in the footer with the record source as
=Sum([Wt])

Yes! There are records returned in the Sub Form (continuous) correctly
displaying the various [Wt]
field values.

I have added another field in the Table called [Volume] whose source in
the sub form will be the
product of [Length]*[Breath]*[Height].

Earlier my intention was just to change to record source of the sub form
to a query. The query
will just have a additonal Field to calculate the Volume at Runtime. I
presume the #Error started
to come as soon as I changed the record source of the Form from Table to
Query.

Hope I have given the required details. Thanks.

Best Regards
B Karthick

Is the Wt control bound to the Wt field in the subform?

The #Error? that you're seeing would suggest that the subform does not
think there is a Wt field anymore, or that there are no records in the
subform's recordsource.

Give us more details about what you changed in the table and in the
subform's recordsource string.

--

Ken Snell
<MS ACCESS MVP>

Dear MVPs and Experts,

I have [Wt] Field and [Wt] Control on a form.
This form is a sub form in another Main Form.
In the footer of the Sub form, I have a calculated
control with source =Sum([Wt]). It was working
properly.

Suddenly, I want to add more fields to this subform.
I have made some addition to the table. I have never
changed the [Wt] field. Now when i changed the record
source of the subform to a query and back to table it
returns #Error.

I have even tried to change the format of the control to
General Number, but nothing seems to work.

Can you please guide me on what went wrong? Thanks
in anticipation.

Best Regards
B Karthick
Access Addict

 

[B Karthick]

Dear Ken Snell,

Given below is the SQL source of the Sub form ...

SELECT Details.[AWB No], Details.Wt, Details.Pcs, Details.Length,
Details.Breath, Details.Height, Details.Volume FROM Details;

As I have mentioned earlier, I have added a Volume Field in the Table
Details and there is no special stored Query for this purpose.

I have a backup of the database which still uses the old structure and
displays the =Sum([Wt]) correctly.

Best Regards
B Karthick
Access Addict

Post the SQL statement of the query that you're now using as the subform's
recordsource. I still think that the #Error? is because the subform does
not "see" a Wt field.

--

Ken Snell
<MS ACCESS MVP>

Dear Ken Snell,

There are two controls

1. the 'Wt' control with the record source as [Wt] in the sub form which
does return the correct value
2. the 'txtSumWt' control in the footer with the record source as
=Sum([Wt])

Yes! There are records returned in the Sub Form (continuous) correctly
displaying the various [Wt]
field values.

I have added another field in the Table called [Volume] whose source in
the sub form will be the
product of [Length]*[Breath]*[Height].

Earlier my intention was just to change to record source of the sub form
to a query. The query
will just have a additonal Field to calculate the Volume at Runtime. I
presume the #Error started
to come as soon as I changed the record source of the Form from Table to
Query.

Hope I have given the required details. Thanks.

Best Regards
B Karthick

Is the Wt control bound to the Wt field in the subform?

The #Error? that you're seeing would suggest that the subform does not
think there is a Wt field anymore, or that there are no records in the
subform's recordsource.

Give us more details about what you changed in the table and in the
subform's recordsource string.

--

Ken Snell
<MS ACCESS MVP>


Dear MVPs and Experts,

I have [Wt] Field and [Wt] Control on a form.
This form is a sub form in another Main Form.
In the footer of the Sub form, I have a calculated
control with source =Sum([Wt]). It was working
properly.

Suddenly, I want to add more fields to this subform.
I have made some addition to the table. I have never
changed the [Wt] field. Now when i changed the record
source of the subform to a query and back to table it
returns #Error.

I have even tried to change the format of the control to
General Number, but nothing seems to work.

Can you please guide me on what went wrong? Thanks
in anticipation.

Best Regards
B Karthick
Access Addict

 

[Ken Snell [MVP]]

Try changing the recordsource back to just the table Details. Does the
summing textbox now show the correct value?

I don't know of any reason that using a query in place of the table name
should give you an error such as you're seeing.

Normally, the #Error error value means that Access cannot evaluate an
expression. Is it possible that the value being calculated by Sum([Wt]) is
larger in size than what the Wt field's fieldsize property is?

--

Ken Snell
<MS ACCESS MVP>

Dear Ken Snell,

Given below is the SQL source of the Sub form ...

SELECT Details.[AWB No], Details.Wt, Details.Pcs, Details.Length,
Details.Breath, Details.Height, Details.Volume FROM Details;

As I have mentioned earlier, I have added a Volume Field in the Table
Details and there is no special stored Query for this purpose.

I have a backup of the database which still uses the old structure and
displays the =Sum([Wt]) correctly.

Best Regards
B Karthick
Access Addict

Post the SQL statement of the query that you're now using as the
subform's recordsource. I still think that the #Error? is because the
subform does not "see" a Wt field.

--

Ken Snell
<MS ACCESS MVP>

Dear Ken Snell,

There are two controls

1. the 'Wt' control with the record source as [Wt] in the sub form which
does return the correct value
2. the 'txtSumWt' control in the footer with the record source as
=Sum([Wt])

Yes! There are records returned in the Sub Form (continuous) correctly
displaying the various [Wt]
field values.

I have added another field in the Table called [Volume] whose source in
the sub form will be the
product of [Length]*[Breath]*[Height].

Earlier my intention was just to change to record source of the sub form
to a query. The query
will just have a additonal Field to calculate the Volume at Runtime. I
presume the #Error started
to come as soon as I changed the record source of the Form from Table to
Query.

Hope I have given the required details. Thanks.

Best Regards
B Karthick


Is the Wt control bound to the Wt field in the subform?

The #Error? that you're seeing would suggest that the subform does not
think there is a Wt field anymore, or that there are no records in the
subform's recordsource.

Give us more details about what you changed in the table and in the
subform's recordsource string.

--

Ken Snell
<MS ACCESS MVP>


Dear MVPs and Experts,

I have [Wt] Field and [Wt] Control on a form.
This form is a sub form in another Main Form.
In the footer of the Sub form, I have a calculated
control with source =Sum([Wt]). It was working
properly.

Suddenly, I want to add more fields to this subform.
I have made some addition to the table. I have never
changed the [Wt] field. Now when i changed the record
source of the subform to a query and back to table it
returns #Error.

I have even tried to change the format of the control to
General Number, but nothing seems to work.

Can you please guide me on what went wrong? Thanks
in anticipation.

Best Regards
B Karthick
Access Addict

 

[B Karthick]

Dear Ken,

The Summing textbox is not bound to any Field in the table. Its is an
unbound control which just calculates the sum in the sub form footer.
I am inturn using this value to calculate the other text boxes of another
sub form.

I will also check whether there is any other control with the same name
in the main form, other sub forms.

Best Regards
B Karthick

Try changing the recordsource back to just the table Details. Does the
summing textbox now show the correct value?

I don't know of any reason that using a query in place of the table name
should give you an error such as you're seeing.

Normally, the #Error error value means that Access cannot evaluate an
expression. Is it possible that the value being calculated by Sum([Wt]) is
larger in size than what the Wt field's fieldsize property is?

--

Ken Snell
<MS ACCESS MVP>

Dear Ken Snell,

Given below is the SQL source of the Sub form ...

SELECT Details.[AWB No], Details.Wt, Details.Pcs, Details.Length,
Details.Breath, Details.Height, Details.Volume FROM Details;

As I have mentioned earlier, I have added a Volume Field in the Table
Details and there is no special stored Query for this purpose.

I have a backup of the database which still uses the old structure and
displays the =Sum([Wt]) correctly.

Best Regards
B Karthick
Access Addict

Post the SQL statement of the query that you're now using as the
subform's recordsource. I still think that the #Error? is because the
subform does not "see" a Wt field.

--

Ken Snell
<MS ACCESS MVP>


Dear Ken Snell,

There are two controls

1. the 'Wt' control with the record source as [Wt] in the sub form
which does return the correct value
2. the 'txtSumWt' control in the footer with the record source as
=Sum([Wt])

Yes! There are records returned in the Sub Form (continuous) correctly
displaying the various [Wt]
field values.

I have added another field in the Table called [Volume] whose source in
the sub form will be the
product of [Length]*[Breath]*[Height].

Earlier my intention was just to change to record source of the sub
form to a query. The query
will just have a additonal Field to calculate the Volume at Runtime. I
presume the #Error started
to come as soon as I changed the record source of the Form from Table
to Query.

Hope I have given the required details. Thanks.

Best Regards
B Karthick


Is the Wt control bound to the Wt field in the subform?

The #Error? that you're seeing would suggest that the subform does not
think there is a Wt field anymore, or that there are no records in the
subform's recordsource.

Give us more details about what you changed in the table and in the
subform's recordsource string.

--

Ken Snell
<MS ACCESS MVP>


Dear MVPs and Experts,

I have [Wt] Field and [Wt] Control on a form.
This form is a sub form in another Main Form.
In the footer of the Sub form, I have a calculated
control with source =Sum([Wt]). It was working
properly.

Suddenly, I want to add more fields to this subform.
I have made some addition to the table. I have never
changed the [Wt] field. Now when i changed the record
source of the subform to a query and back to table it
returns #Error.

I have even tried to change the format of the control to
General Number, but nothing seems to work.

Can you please guide me on what went wrong? Thanks
in anticipation.

Best Regards
B Karthick
Access Addict

 

[Ken Snell [MVP]]

I understand that your summing textbox is not bound to a field in the
subform's RecordSource. You would not be able to use the =Sum() expression
as its control source if it were bound to a field.

My recommendation for changing the subform's recordsource is from your
statement that the problem began when you changed from the table directly to
a query. I'm just trying to retrace steps here to see what happens.
--

Ken Snell
<MS ACCESS MVP>

Dear Ken,

The Summing textbox is not bound to any Field in the table. Its is an
unbound control which just calculates the sum in the sub form footer.
I am inturn using this value to calculate the other text boxes of another
sub form.

I will also check whether there is any other control with the same name
in the main form, other sub forms.

Best Regards
B Karthick

Try changing the recordsource back to just the table Details. Does the
summing textbox now show the correct value?

I don't know of any reason that using a query in place of the table name
should give you an error such as you're seeing.

Normally, the #Error error value means that Access cannot evaluate an
expression. Is it possible that the value being calculated by Sum([Wt])
is larger in size than what the Wt field's fieldsize property is?

--

Ken Snell
<MS ACCESS MVP>

Dear Ken Snell,

Given below is the SQL source of the Sub form ...

SELECT Details.[AWB No], Details.Wt, Details.Pcs, Details.Length,
Details.Breath, Details.Height, Details.Volume FROM Details;

As I have mentioned earlier, I have added a Volume Field in the Table
Details and there is no special stored Query for this purpose.

I have a backup of the database which still uses the old structure and
displays the =Sum([Wt]) correctly.

Best Regards
B Karthick
Access Addict


Post the SQL statement of the query that you're now using as the
subform's recordsource. I still think that the #Error? is because the
subform does not "see" a Wt field.

--

Ken Snell
<MS ACCESS MVP>


Dear Ken Snell,

There are two controls

1. the 'Wt' control with the record source as [Wt] in the sub form
which does return the correct value
2. the 'txtSumWt' control in the footer with the record source as
=Sum([Wt])

Yes! There are records returned in the Sub Form (continuous) correctly
displaying the various [Wt]
field values.

I have added another field in the Table called [Volume] whose source
in the sub form will be the
product of [Length]*[Breath]*[Height].

Earlier my intention was just to change to record source of the sub
form to a query. The query
will just have a additonal Field to calculate the Volume at Runtime. I
presume the #Error started
to come as soon as I changed the record source of the Form from Table
to Query.

Hope I have given the required details. Thanks.

Best Regards
B Karthick


Is the Wt control bound to the Wt field in the subform?

The #Error? that you're seeing would suggest that the subform does
not think there is a Wt field anymore, or that there are no records
in the subform's recordsource.

Give us more details about what you changed in the table and in the
subform's recordsource string.

--

Ken Snell
<MS ACCESS MVP>


Dear MVPs and Experts,

I have [Wt] Field and [Wt] Control on a form.
This form is a sub form in another Main Form.
In the footer of the Sub form, I have a calculated
control with source =Sum([Wt]). It was working
properly.

Suddenly, I want to add more fields to this subform.
I have made some addition to the table. I have never
changed the [Wt] field. Now when i changed the record
source of the subform to a query and back to table it
returns #Error.

I have even tried to change the format of the control to
General Number, but nothing seems to work.

Can you please guide me on what went wrong? Thanks
in anticipation.

Best Regards
B Karthick
Access Addict

 

[B Karthick]

Dear Ken,

I have done several changes. In order to solve the problem quickly, I have
imported the sub form from my back up and it works. Then again I did all the
required changes carefully eyeing whether the summing Text box changes. It
never changed after adding a Field in the Parent Form, Sub form and renaming
a absolete control to the new control source. But, when I added some more
Summing Text on the form and accidently left out the "(" or "[" in the
=Sum([VolWt]) in the control
source there was a cascading effect in the =Sum([Wt]) control too. In fact
all the summing Text Boxes displayed #Error.

Sorry for making everyone break their head for the laziness or lathargy on
my part to type the control source correctly.

Problem rectified! Thank you very much.

Best Regards
B Karthick
Access Addict

I understand that your summing textbox is not bound to a field in the
subform's RecordSource. You would not be able to use the =Sum() expression
as its control source if it were bound to a field.

My recommendation for changing the subform's recordsource is from your
statement that the problem began when you changed from the table directly
to a query. I'm just trying to retrace steps here to see what happens.
--

Ken Snell
<MS ACCESS MVP>

Dear Ken,

The Summing textbox is not bound to any Field in the table. Its is an
unbound control which just calculates the sum in the sub form footer.
I am inturn using this value to calculate the other text boxes of another
sub form.

I will also check whether there is any other control with the same name
in the main form, other sub forms.

Best Regards
B Karthick

Try changing the recordsource back to just the table Details. Does the
summing textbox now show the correct value?

I don't know of any reason that using a query in place of the table name
should give you an error such as you're seeing.

Normally, the #Error error value means that Access cannot evaluate an
expression. Is it possible that the value being calculated by Sum([Wt])
is larger in size than what the Wt field's fieldsize property is?

--

Ken Snell
<MS ACCESS MVP>


Dear Ken Snell,

Given below is the SQL source of the Sub form ...

SELECT Details.[AWB No], Details.Wt, Details.Pcs, Details.Length,
Details.Breath, Details.Height, Details.Volume FROM Details;

As I have mentioned earlier, I have added a Volume Field in the Table
Details and there is no special stored Query for this purpose.

I have a backup of the database which still uses the old structure and
displays the =Sum([Wt]) correctly.

Best Regards
B Karthick
Access Addict


Post the SQL statement of the query that you're now using as the
subform's recordsource. I still think that the #Error? is because the
subform does not "see" a Wt field.

--

Ken Snell
<MS ACCESS MVP>


Dear Ken Snell,

There are two controls

1. the 'Wt' control with the record source as [Wt] in the sub form
which does return the correct value
2. the 'txtSumWt' control in the footer with the record source as
=Sum([Wt])

Yes! There are records returned in the Sub Form (continuous)
correctly displaying the various [Wt]
field values.

I have added another field in the Table called [Volume] whose source
in the sub form will be the
product of [Length]*[Breath]*[Height].

Earlier my intention was just to change to record source of the sub
form to a query. The query
will just have a additonal Field to calculate the Volume at Runtime.
I presume the #Error started
to come as soon as I changed the record source of the Form from Table
to Query.

Hope I have given the required details. Thanks.

Best Regards
B Karthick


Is the Wt control bound to the Wt field in the subform?

The #Error? that you're seeing would suggest that the subform does
not think there is a Wt field anymore, or that there are no records
in the subform's recordsource.

Give us more details about what you changed in the table and in the
subform's recordsource string.

--

Ken Snell
<MS ACCESS MVP>


Dear MVPs and Experts,

I have [Wt] Field and [Wt] Control on a form.
This form is a sub form in another Main Form.
In the footer of the Sub form, I have a calculated
control with source =Sum([Wt]). It was working
properly.

Suddenly, I want to add more fields to this subform.
I have made some addition to the table. I have never
changed the [Wt] field. Now when i changed the record
source of the subform to a query and back to table it
returns #Error.

I have even tried to change the format of the control to
General Number, but nothing seems to work.

Can you please guide me on what went wrong? Thanks
in anticipation.

Best Regards
B Karthick
Access Addict