Hi Guy's, On a report i have a text box not bound to a field but looking up a mobile number form contacts table
If there is no mobile number added, i get #error
Text Box Control Source:
How do i not add anything if a mobile number doesn't exist ?Code:=DLookUp("Mobile","tblDealers","[PostCode] = txtPostCode And [Name] = txtDelTo")
do i use Iif or Nz
if so, how do i write it in ?
much appreciated