Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Apr 28, 2022

#Error on New Record

Experts, I am trying to get rid of the #error on the new row in my datasheet (pic below).   I am using this formula: =iif(IsError(DLookUp("[Rate]","qryPricingNow","[ProjID]=" & [ProjID])),"",DLookU...
  • arnel_gp's avatar
    Apr 28, 2022
    try this:

    =DLookUp("[Rate]","qryPricingNow","[ProjID]=" & Nz([ProjID], 0))

Resources