How can I change this line to use it in a report?

[NeoZakz]

=DLookUp("[suppl]","MAKEBUY","[part]=Forms![Change Board Records]![P_N]&quot

Thats the line I'm trying to change to use in a report for the same information. I tried to change it to this:

=DLookUp("[suppl]","MAKEBUY","[part]= Reports![CBR Report]![P_N]&quot

But that didn't work. Anyone got any ideas?

 

[oharab]

=DLookUp("[suppl]","MAKEBUY","[part]='" & Reports![CBR Report]![P_N] & "'&quot

should do it for you.


Ben
----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------

 

[NeoZakz]

Thanks a lot, I'll go give it a shot now.