Dlookup returning null

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top