Problem with a control in a report: It returns #Name? 1

[Lreader]

I have a control in a report and it refers to a field in a table . Both report and table are in the same database. In that table I have a unique record.

In SourceControl of the report control, I wrote:

![MyField]
I tried to add: =[MyTable]![MyField]
but it still returns #Name?


I looked in Access help and I think I tried everything the help suggest: Check file name and field name,Msowcf.dll on my computer (I use Assess 2000).I have no space in the table name and in the field name.

Anyone has an idea please?

 

[gwinn7]

Why not click the down arrow of the ControlSource and select the field?

Gary
gwinn7

 

[Lreader]

I forgot one thing:
My report is not based on the table from where I need the field, so I can't see the requested field in the drop down area.

I tried to use the "expression generator" and I built the expression [MyTable]![MyField]with it.I don't need to add criteria. I only want the control to show the data from that field. The generator can see my table and my field but I still have #Name? in my report's control.

 

[gwinn7]

If your report is not based on recordSource like a table or a query, which seems strange in anyway, why not use the Dlookup function?

Gary
gwinn7