If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#name?
I have a report with a query. I added to the query a field called "soccer".
On the report I reference the field in an equation =sum([os])+[soccer]. However, I'm getting a #name? on the equation field. When I look at the report the soccer field has a green box indicating a problem When I open that it tells me it's an invalid control. Why? I took it immediately from the field selector, so I know its valid. Any help would be appreciated. by theby using Access 2007. Thanks. Margaret |
#2
|
|||
|
|||
#name?
Margaret,
Without more details here are a few things to check... 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. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "margaret" wrote in message ... I have a report with a query. I added to the query a field called "soccer". On the report I reference the field in an equation =sum([os])+[soccer]. However, I'm getting a #name? on the equation field. When I look at the report the soccer field has a green box indicating a problem When I open that it tells me it's an invalid control. Why? I took it immediately from the field selector, so I know its valid. Any help would be appreciated. by theby using Access 2007. Thanks. Margaret |
Thread Tools | |
Display Modes | |
|
|