#Name? problem

[CD Tom]

I've switched from 2003 to 2007 and am now having a problem with a report
that worked fine before. In the report I have some code in the Groupfooter0
event that calculates some times. One line of the code is this
cctime1 = DSum("[Time1]", "[stagestats]", "[Time1] < 999 and class = '"
& Class & "'")
in the report I have the control source set to =[cctime1] now all I get when
the report is run is #Name? in that field. Don't understand why it works in
2003 and not in 2007 any help would be appreciated.
Thanks

 

[Gina Whipp]

CD Tom,

Here are some reasons...

1. Make sure that the field specified in the control's ControlSource
property hasn't been removed from the underlying table or record source.

2. Check the spelling of the field name in the control's ControlSource
property.

3. If you specified an expression in the control's ControlSource property,
make sure that there is an equal sign preceding the expression.

4. Make sure the names of the field does not match the name of any of the
controls in your formula

5. Check for missing references

See if any of those apply to you. If not post back.

As a side note, *class* is a Reserved Word. Access 2003 was far more
forgiving then Access 2007, so I would suggest fixing that field name. For
a complete list of Reserved Words see...
http://allenbrowne.com/AppIssueBadWord.html#C

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm