Access 2007 subform total.

[jjjax]

We were running .adp's on Access 2000 and are in the process of updating to
Access 2007. Most things seem to working fine under 2007 but running into
some problems with a couple of forms that have subforms. Not all but the
couple I am having a big problem with are doing totals in form footer. These
are just totals from detail in subform itself not even looking at main form's
data and when open subform by itself, it displays fine. I checked all I
could but just getting #error in the total fields but detail fields look
good. I added a button that does just a me.refresh and when click it,
everything seems fine but I tried finding a place after form loads to do it
automatically but nothing seems to work. This all still works fine on pc's
with Access 2000 but not on 2007. Any help? Thanks, Joe

 

[Jeanette Cunningham]

Hi Joe,
you need a wrapper function for totals in unbound controls in
A2007

here is the link that explains it all
http://allenbrowne.com/RecordCountError.html



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[gael]

We were running .adp's on Access 2000 and are in the process of updating
to
Access 2007. Most things seem to working fine under 2007 but running into
some problems with a couple of forms that have subforms. Not all but the
couple I am having a big problem with are doing totals in form footer.
These
are just totals from detail in subform itself not even looking at main
form's
data and when open subform by itself, it displays fine. I checked all I
could but just getting #error in the total fields but detail fields look
good. I added a button that does just a me.refresh and when click it,
everything seems fine but I tried finding a place after form loads to do
it
automatically but nothing seems to work. This all still works fine on
pc's
with Access 2000 but not on 2007. Any help? Thanks, Joe

sava pas caca toi

 

[gael]

We were running .adp's on Access 2000 and are in the process of updating
to
Access 2007. Most things seem to working fine under 2007 but running into
some problems with a couple of forms that have subforms. Not all but the
couple I am having a big problem with are doing totals in form footer.
These
are just totals from detail in subform itself not even looking at main
form's
data and when open subform by itself, it displays fine. I checked all I
could but just getting #error in the total fields but detail fields look
good. I added a button that does just a me.refresh and when click it,
everything seems fine but I tried finding a place after form loads to do
it
automatically but nothing seems to work. This all still works fine on
pc's
with Access 2000 but not on 2007. Any help? Thanks, Joe

 

[gael]

We were running .adp's on Access 2000 and are in the process of updating
to
Access 2007. Most things seem to working fine under 2007 but running into
some problems with a couple of forms that have subforms. Not all but the
couple I am having a big problem with are doing totals in form footer.
These
are just totals from detail in subform itself not even looking at main
form's
data and when open subform by itself, it displays fine. I checked all I
could but just getting #error in the total fields but detail fields look
good. I added a button that does just a me.refresh and when click it,
everything seems fine but I tried finding a place after form loads to do
it
automatically but nothing seems to work. This all still works fine on
pc's
with Access 2000 but not on 2007. Any help?2009 Thanks, Joe