#Name? showing on subform

[stardust1979]

Hi All,

I have a problem with a subform - on one column (named comments - which is a text field) it loads and shows "#Name?". If I open the subform on it's own it shows the data correctly, if I run the source query it works fine - I have other text columns that all work fine, it just seems to be a problem with this text field and only when viewing the subform from the main form.

Any ideas?

 

[burrina]

Is their code behind the control? Are you using calculated expressions?
Have you checked the name controls to make sure they are correct?

 

[smig]

Make sure you are not changing the recor source by the top form

 

[Mihail]

Are you very sure that that column contain text ? I suspect that the column contain an ID (a key).
Take a closer look at the subform's query (record source).

 

[jdraw]

As others have said, there is an issue with the control involved. For some reason(s), the control is unknown or has an error in calculation/expression.

You should review
- the Control Source of the Control
- the record source of the Form

Seems it was solved here
http://www.accessforums.net/forms/name-error-when-loading-subform-49169.html

When you cross post -post the same question on multiple sites - you should tell the readers on that site that you have done so. It isn't wrong to cross post, but have the courtesy to tell people you have done so. And point to the solution when/if it is solved.