#Name?

[3divine]

Hello! Help!

Unfortunately I have a very complicated database and without using lots of verbiage I have narrow down the situation and hopefully someone will understand what I'm trying to explain here.

txt298 in form2 has value that is coming from form1 and this is what I have in control source:

=[Forms]![frmForm1]![txt297]

When I open form2 the text box displays this #Name? instead.

I have referred to the help in Access 97 for this topic #Error? or #Name? appears in a control but still have no clue what's missing, so perhaps someone could give me another idea?

Thanks

 

[pdx_man]

Hmmm ... Some thoughts:
Immediately, I would say that you are opening Form2 without having Form1 open. If this is true, that is your problem. Otherwise, just try to reference another control on Form1 and see if you can at least do that. Confirm that txt297 does, in fact, still exist on Form1. Perhaps create a very unique name instead of txt297 so that Access is not getting confused.

 

[3divine]

Thanks!