#name? Unbound text box calcualation using two other unbound text boxes

[Kregg]

I am running in to a brick wall with this. I have an unbound text box with the control source set to =IIF([text42]=0,0,[text42]/[text44])*100 and in continues to return a #name? error.

I am not sure how to get this expression to work. I have even tried to put =[text42]/[text44] and I still get the #name? error.

Can anyone help me with this issue? Any help would be greatly appreciated. Thanks in advance!

 

[boblarson]

Are those controls bound to any fields? If so, try using the name of the field instead of the control. (also rename your controls to something useful so someone coming in, after you are gone (or you coming back 6 months later), looking at text42 won't wonder what that means.

 

[Kregg]

Are those controls bound to any fields? If so, try using the name of the field instead of the control. (also rename your controls to something useful so someone coming in, after you are gone (or you coming back 6 months later), looking at text42 won't wonder what that means.

[Text42] and [Text44] are not bound to anything. They hold Count(functions based on two fields on the form.

Renaming the controls is a good idea.

Any other ideas for dividing two unbound text boxes?

 

[boblarson]

You will likely need to use the same functions that those text boxes use in that other text box instead of referring to the text boxes.