Dlookup returning null

K

Karl H

Can someone help determine why this DLookup is returning null & the Nz
function takes over?

Me.frmXAdjust.Value = CInt(Nz(DLookup("XAdjustment", _
"tblPrinterAdjust", "PKDescription = 'PrintAdjust'"), 3))

There is a table: tblPrinterAdjust, and data in the XAdjustment field where
PKDescription = PrintAdjust

Thank you,
Karl
 
Top