Forum Discussion
Tony2021
Apr 28, 2022Steel Contributor
#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...
- Apr 28, 2022try this:
=DLookUp("[Rate]","qryPricingNow","[ProjID]=" & Nz([ProjID], 0))