DLookup in Report (1 Viewer)

[CTQE]

Hello Everyone!,
A quick question to you folks...

What would be the correct DLookup syntax to perform the following operation:

I need to bring in a value from a field named "Description" from a table called "PNs and Desc". The "Description" should be relative to another field named "PN" (located in another table).

Any ideas?

Thnx in advance!

 

[Treason]

=Dlookup("[Description]", "PNs and Desc", "[PN] = " & MyPNVar)

The hard part would be getting MyPNVar equal to the right record. if the PN is already on your form then you could do:

Dlookup("[Description]", "PNs and Desc", "[PN] = " & forms!myformname.PN)