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? appears in form field, even though it worked before I saved
I have created a form with a calculated field with the control name
"ItemCost." I can save the form and the field calculates and returns appropriate values. HOWEVER, when I close the database, restart the database, and open the form, the "#Name?" appears in the field. At this point, I go into the design and change the name of the control to "ItemCost1," for example, and the field caclulates and returns values. I save the form and everything works fine...until I close the database again. How can I resolve this issue? Thanks! |
#2
|
|||
|
|||
#Name? appears in form field, even though it worked before I saved
it doesn't seem to be able to find all the necessary values for the
calculation during the opening but works once opened.... you mention closing and opening the entire db rather than just the form....double check where your values originate from.... -- NTC "Sara M" wrote: I have created a form with a calculated field with the control name "ItemCost." I can save the form and the field calculates and returns appropriate values. HOWEVER, when I close the database, restart the database, and open the form, the "#Name?" appears in the field. At this point, I go into the design and change the name of the control to "ItemCost1," for example, and the field caclulates and returns values. I save the form and everything works fine...until I close the database again. How can I resolve this issue? Thanks! |
#3
|
|||
|
|||
#Name? appears in form field, even though it worked before I saved
Do you have a field named ItemCost in the table or query that the form is
using as its RecordSource? By chance, is that field used in the expression that you have as the control's ControlSource? That often is the cause of the problem. If you're using ItemCost field in a control's ControlSource expression, the name of that control must be different than the field name. -- Ken Snell MS ACCESS MVP "Sara M" wrote in message ... I have created a form with a calculated field with the control name "ItemCost." I can save the form and the field calculates and returns appropriate values. HOWEVER, when I close the database, restart the database, and open the form, the "#Name?" appears in the field. At this point, I go into the design and change the name of the control to "ItemCost1," for example, and the field caclulates and returns values. I save the form and everything works fine...until I close the database again. How can I resolve this issue? Thanks! |
#4
|
|||
|
|||
#Name? appears in form field, even though it worked before I saved
"Sara M" wrote in message ... I have created a form with a calculated field with the control name "ItemCost." I can save the form and the field calculates and returns appropriate values. HOWEVER, when I close the database, restart the database, and open the form, the "#Name?" appears in the field. At this point, I go into the design and change the name of the control to "ItemCost1," for example, and the field caclulates and returns values. I save the form and everything works fine...until I close the database again. How can I resolve this issue? Thanks! |
#5
|
|||
|
|||
#Name? appears in form field, even though it worked before I s
No, I don't have a field with the same name in the underlying table or query.
I have checked all of my control name's and it's not a duplicate. I even tried deleting the control and creating a new one, named [ItemCosts], but I had the same problem. So, my fix was to add the calculation to the underlying query, rather than in the form itself. Now, the query calculates properly, and the form displays the correct data. Thanks. "Ken Snell (MVP)" wrote: Do you have a field named ItemCost in the table or query that the form is using as its RecordSource? By chance, is that field used in the expression that you have as the control's ControlSource? That often is the cause of the problem. If you're using ItemCost field in a control's ControlSource expression, the name of that control must be different than the field name. -- Ken Snell MS ACCESS MVP "Sara M" wrote in message ... I have created a form with a calculated field with the control name "ItemCost." I can save the form and the field calculates and returns appropriate values. HOWEVER, when I close the database, restart the database, and open the form, the "#Name?" appears in the field. At this point, I go into the design and change the name of the control to "ItemCost1," for example, and the field caclulates and returns values. I save the form and everything works fine...until I close the database again. How can I resolve this issue? Thanks! |
#6
|
|||
|
|||
#Name? appears in form field, even though it worked before I s
Your solution is actually a very good one to use. Good work and good luck.
-- Ken Snell MS ACCESS MVP "Sara M" wrote in message ... No, I don't have a field with the same name in the underlying table or query. I have checked all of my control name's and it's not a duplicate. I even tried deleting the control and creating a new one, named [ItemCosts], but I had the same problem. So, my fix was to add the calculation to the underlying query, rather than in the form itself. Now, the query calculates properly, and the form displays the correct data. |
Thread Tools | |
Display Modes | |
|
|