Access2K vs Access2002 Sums

[laurenq uantrell]

I am using a control MyTotal on a subform footer to get a sum of all
rows on the subform: =Sum([Amount])
On the main form I have a control whose controlsource is:
=Forms!FormName.Child.Form.MyTotal.
This displays the sum of the subform.
It works fine on Access 2000 but displays an error in Access 2002. I
can't figure this one out.
lq

[Bruno Campanini]

"laurenq uantrell" <la*************@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

I am using a control MyTotal on a subform footer to get a sum of all
rows on the subform: =Sum([Amount])
On the main form I have a control whose controlsource is:
=Forms!FormName.Child.Form.MyTotal.
This displays the sum of the subform.
It works fine on Access 2000 but displays an error in Access 2002. I
can't figure this one out.
lq

It should be = Me . [MySubForm] . Form ! [MyTotal]

Do you really use "Child" as the name for your subform?
May be "Child" is a reseved word for Access 2002.

Bruno

[Larry Linson]

"Bruno Campanini" wrote

I am using a control MyTotal on a subform
footer to get a sum of all rows on the subform:
=Sum([Amount])
On the main form I have a control whose
controlsource is:
=Forms!FormName.Child.Form.MyTotal.
This displays the sum of the subform.
It works fine on Access 2000 but displays
an error in Access 2002. I
can't figure this one out.
lq

It should be = Me . [MySubForm] . Form ! [MyTotal]

Do you really use "Child" as the name for your subform?
May be "Child" is a reseved word for Access 2002.

Bruno

A form could have two SubForm controls at the same level -- which one would
be the "Child"? I don't have Access 2000 handy to try, but I would expect it
to give some kind of error. "Parent", on the other hand, is unambigous.

Larry Linson
Microsoft Access MVP

[laurenq uantrell]

Larry,
I renammed the subform "Child1" and still have the same problem.
I have always used the naming convention of naming a subform "Child"
and the second subform Child2, etc. It has been a big help in
simplifying code, such as allowing me to create generic code for
changing control attributes and the like.

I realized this problem went even deeper. In this user environment
there are two machines running Access2002 and this happens only on one
machine! Both are running Windows2000.

I am completely baffled.

When I go to the culprit machine, I installed this subform as a
continuous form (instead of a datasheet) which allowed me to see the
sum control ctlMySum in the subform's form footer containing the
controlsource "=Sum([Amount])"
On the offending machine, this control is blank! So the control on the
Parent form that has the controlsource
"=Forms!FormName.CHild.Form.ctlMySum" returns an error. However, on all
other machines it's fine.

lq

Larry Linson wrote:

"Bruno Campanini" wrote

> > I am using a control MyTotal on a subform
> > footer to get a sum of all rows on the subform:
> > =Sum([Amount])
> > On the main form I have a control whose
> > controlsource is:
> > =Forms!FormName.Child.Form.MyTotal.
> > This displays the sum of the subform.
> > It works fine on Access 2000 but displays
> > an error in Access 2002. I
> > can't figure this one out.
> > lq >
> It should be = Me . [MySubForm] . Form ! [MyTotal]
>
> Do you really use "Child" as the name for your subform?
> May be "Child" is a reseved word for Access 2002.
>
> Bruno

A form could have two SubForm controls at the same level -- which one

would be the "Child"? I don't have Access 2000 handy to try, but I would expect it to give some kind of error. "Parent", on the other hand, is unambigous.
Larry Linson
Microsoft Access MVP

[Trevor Best]

laurenq uantrell wrote:

[snip]

What happened to your "q"? :-)

--
This sig left intentionally blank

[Larry Linson]

I don't know what the problem is. Some things to check are:

(1) Was the install of Access successful on that machine? (If not,
uninstall and reinstall.)
(2) What are the differences in Operating System setup between the machine
where it works and the one where it doesn't work?
(3) Are there any differences in Access' Tools | Options between the
machine where it works and the one where it doesn't work?
(4) Are there _any_ differences in the front-end database (assuming you
are working with a front-end/back-end split database) on those machines?
(5) Are there any differences in the data being accessed on the two
machines?

Even with the answers to all these questions, it may not be obvious what the
problem is.

Larry Linson
Microsoft Access MVP
"laurenq uantrell" <la*************@hotmail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

Larry,
I renammed the subform "Child1" and still have the same problem.
I have always used the naming convention of naming a subform "Child"
and the second subform Child2, etc. It has been a big help in
simplifying code, such as allowing me to create generic code for
changing control attributes and the like.

I realized this problem went even deeper. In this user environment
there are two machines running Access2002 and this happens only on one
machine! Both are running Windows2000.

I am completely baffled.

When I go to the culprit machine, I installed this subform as a
continuous form (instead of a datasheet) which allowed me to see the
sum control ctlMySum in the subform's form footer containing the
controlsource "=Sum([Amount])"
On the offending machine, this control is blank! So the control on the
Parent form that has the controlsource
"=Forms!FormName.CHild.Form.ctlMySum" returns an error. However, on all
other machines it's fine.

lq

Larry Linson wrote:

"Bruno Campanini" wrote

> > I am using a control MyTotal on a subform
> > footer to get a sum of all rows on the subform:
> > =Sum([Amount])
> > On the main form I have a control whose
> > controlsource is:
> > =Forms!FormName.Child.Form.MyTotal.
> > This displays the sum of the subform.
> > It works fine on Access 2000 but displays
> > an error in Access 2002. I
> > can't figure this one out.
> > lq
>
> It should be = Me . [MySubForm] . Form ! [MyTotal]
>
> Do you really use "Child" as the name for your subform?
> May be "Child" is a reseved word for Access 2002.
>
> Bruno

A form could have two SubForm controls at the same level -- which one

would

be the "Child"? I don't have Access 2000 handy to try, but I would

expect it

to give some kind of error. "Parent", on the other hand, is

unambigous.

Larry Linson
Microsoft Access MVP