#Error as DLOOKUP result

  • Thread starter Thread starter GD
  • Start date Start date
G

GD

I'm using the following:

=DLookUp("[NAME]","006_Employee_tbl","[EMP#]=" &
DLookUp("[EMPNO]","005_DMLog_tbl","[DM#]=[Forms]![002PaybackEntry_frm]![txtFergusonChargeback#]"))

It works fine when txtFergusonChargeback# is in 005_DMLog_tbl. But when it
isn't it returns "#Error". I need it to stay blank in that case. Any
suggestions?

Thanks!!
 
The problem is that the inner DLookup is returning Null, and you can't use
Null with =.

Try:

=DLookUp("[NAME]","006_Employee_tbl","[EMP#]=" &
Nz(DLookUp("[EMPNO]","005_DMLog_tbl","[DM#]=[Forms]![002PaybackEntry_frm]![txtFergusonChargeback#]"),
0))

or even

=Nz(DLookUp("[NAME]","006_Employee_tbl","[EMP#]=" &
Nz(DLookUp("[EMPNO]","005_DMLog_tbl","[DM#]=[Forms]![002PaybackEntry_frm]![txtFergusonChargeback#]"),
0)), "Not found")
 
Genius! Thanks, Doug!
--
GD


Douglas J. Steele said:
The problem is that the inner DLookup is returning Null, and you can't use
Null with =.

Try:

=DLookUp("[NAME]","006_Employee_tbl","[EMP#]=" &
Nz(DLookUp("[EMPNO]","005_DMLog_tbl","[DM#]=[Forms]![002PaybackEntry_frm]![txtFergusonChargeback#]"),
0))

or even

=Nz(DLookUp("[NAME]","006_Employee_tbl","[EMP#]=" &
Nz(DLookUp("[EMPNO]","005_DMLog_tbl","[DM#]=[Forms]![002PaybackEntry_frm]![txtFergusonChargeback#]"),
0)), "Not found")

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


GD said:
I'm using the following:

=DLookUp("[NAME]","006_Employee_tbl","[EMP#]=" &
DLookUp("[EMPNO]","005_DMLog_tbl","[DM#]=[Forms]![002PaybackEntry_frm]![txtFergusonChargeback#]"))

It works fine when txtFergusonChargeback# is in 005_DMLog_tbl. But when
it
isn't it returns "#Error". I need it to stay blank in that case. Any
suggestions?

Thanks!!
Click to expand...
Click to expand...
 
Back
Top