Form will not use textboxes from form, gives #Name?

[FrenchUser]

Hi, first thank you for all your help, reading these forums has been a life saver for creating my database. One question: I created a textbox with the record set:



=IIf([Combo41]>=[Combo37] And [Combo41]>=[Combo39],[Combo41],IIf([Combo37]>=[Combo39],[Combo37],[Combo39])).

And it worked well until I saved, closed, and reopened the database. Now it shoes #Name?. From the forums I recognize that the problem probably is in the field list, but I'm not sure how to fix it.
I would welcome any suggestions, thanks again for all the help.

[ssanfu]

Check the names of the combo boxes.
The "#NAME" error usually means that Access cannot find a control with that name.

I always rename the control to something more meaningful...... to me, at least

[FrenchUser]

ssanfu, Thank you very much for your relpy. Unfortunately, I've tried checking the names of the combo boxes, and changing them, but I still get the same error. Now, when I try to just type =Combo41, the name does not even come up. Does this indicate a different problem? Thank you again for your help.

[ssanfu]

Maybe the form is corrupt??? Have you tried a "Compile and Repair"?

Create a new form and add just the combo boxes and the text box. Do you get the correct value in the text box?

[FrenchUser]

I did try to compile and repair, which did not solve the problem. If I create a new form, it does work. I will recreate the form then, thank you for your help. For the future, do you know why this may have happened so I can avoid it when I recreate the form?

[ssanfu]

I think it could be the result of the "Butterfly Effect".
Or maybe a Quark rotated the wrong direction.... or ???
Sometimes, things just happen....

[FrenchUser]

Well, thank you for the help, I really appreciate it!