DLookup in Report displays Name#

[MaddiMond]

I tried to use DLookUp in the expression of a control on a report to lookup a value in a query. I get Name# and I think it might have to do that I have to criteria.
"[EmployeeID]"= Forms![rptMain]![EmployeeID] & "[YearMonth]"=Forms![rptMain]![MonthYear])

Or can I not lookup values in a query?
How can I accomplish anything like this?

Thanks.

Maddi

 

[Tash]

Could you explain a little bit more what you are trying to show in the field? Is [EmployeeID] the field name? If you are trying to use the Dlookup function, it should look something like this:

DLookup("FieldName" , "TableName" , "Criteria = n")

Not sure if you can grab it from a query, but you may be able to get the value from the table and then re-create the value on the form that you are using.

 

[Remou]

How about:
[tt]"[EmployeeID]=" & Forms![rptMain]![EmployeeID] & " AND [YearMonth]=" & Forms![rptMain]![MonthYear])[/tt]

Assuming that both fields are numeric.