memo data wont pass to report

[ppoindexter]

i have a text box "textMemo" (data type = memo) on a form that is populated by "textMemo1" (data type = memo)

=Forms!frmMenuReports!subfrmReportMemo!textMemo1

textMemo populates a text box (Tmemo) on a report

=Forms!frmMenuReports!textMemo.column(2)

when i open the report i get
#Name in Tmemo on the report

i use the same code for passing text from a combobox on the same form and it works fine

any help is appreciated

 

[RuralGuy]

Try:
=Forms!frmMenuReports!subfrmReportMemo.Form!textMemo1

 

[ppoindexter]

i get the same error
#Name

 

[RuralGuy]

Make sure the SubFormControl name is correct. The syntax is:

Forms!MainFormName!SubFormControlName.Form!ControlName

The SubFormControlName needs to be the name of the SubFormControl and not necessarily the name of the SubForm. Forms are displayed on other forms by means of a SubFormControl. This SubFormControl has it's own name which does not have to be the name of the SubForm it is displaying. You know you are looking at the SubFormControl when the data tab of the property sheet shows the LinkChild/MasterFields entries. The name is on the Other tab.

 

[ppoindexter]

i got it somehow
i changed the name of the textbox and it started working
thanks for all your help