What is this telling me? #Name?

[msreed]

Does this error generally indicate a particular problem? I am trying to debug and so far I haven't found my problem. I have a form/suform issue. In the main form I am calling on a calculated field in the subform. I have this exact situation working in another area so I can't figure out why this one is giving me the #Name?. Not to mention I don't know what it means! Thanks.

 

[psemianonymous]

#Name means it can't find the control or field or whatever you've typed in the source for that particular textbox.


So if you put "=txtSomeControlthatDoesntExist" it would give you a #Name error. OR, more likely,

if you put "=txtSomeControlOnTheMainForm" it would do the same. Use:

"=Me.Parent.txtSomeControlOnTheMainForm" instead.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[psemianonymous]

Oops, redux. If you're getting the #Name error on the MAIN form, do this:

ctlNAME_OF_SUBFORM_CONTROL_NOT_THE_NAME_OF_THE_SUBFORM_ITSELF.Form.ctlTHE_CONTROL_ON_THE_SUBFORM

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[msreed]

Foolio, so far no go. I think I might be confused on what you are telling me to do. The field on the main form should grab the field from the subform so I am looking at your 2nd post.

txtFlag = the text box in subform
=sum(iif([Pay]=-1,[Balance],0)) = the control of txtFlag
txtToPay = the field in the main form I'm asking to populate

Are you telling me to type:
"ctltxtFlag.Form.ctl=sum(iif([Pay]=-1,[Balance],0))"

 

[psemianonymous]

1. Find your subform "box" on the main form
2. Go to properties, Other
3. Type in a meaningful name (i.e. subCtl or something you remember)
4. Now go to txtToPay,
5. Control Source: "=subCtl.Form.txtFlag"

 

[msreed]

Hurray Foolio! Thank you, as I was getting tired of messing with it.