#Name? error when loading a 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?

[June7]

Is this a calculated field in the subform RecordSource or is it an expression in textbox ControlSource?

Post the expression.

[stardust1979]

Thanks I seem to have fixed it by removing the subform from the form and replacing it again - go figure!!