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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Control afterupdate - run from module - insert data - set flag 3
Access #Error & Excel Pivot 0
getting certain fields from a particular record 3
How do I do this in VBA? 5
Access ACCESS DLOOKUP INVALID USE OF NULL 0
DLookup error 1
Returning Null with Dlookup 7
open arguments. 17

Back
Top