Why doesnt this work?

=DLookUp("[Masternr]";"Masterinfo";"Masterinfo.Masternr = " & [Masternr])

cant i look up values from other tables in a report?
Masternr is both a field in my recordsource, and a filed in the table Masterinfo, which is not in the recordsource.

What is wrong here?