Report Field Control Source

[DMT Dave]

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:

=DLookUp("Mobile","tblDealers","[PostCode] = txtPostCode And [Name] = txtDelTo")

How do i not add anything if a mobile number doesn't exist ?

do i use Iif or Nz

if so, how do i write it in ?

much appreciated

[CJ_London]

Think your dlookup is wrong. These are text values so would think it would need to be

=DLookUp("Mobile","tblDealers","[PostCode] = '" & txtPostCode & "'And [Name] = '" & txtDelTo & "'")

which should return a zls if nothing found

[DMT Dave]

Ahh thank s CJ London, so just need to add string delimiters in there even though the criteria's are text boxes with no control source ?

KR

Dave

[Welshgasman]

The textboxes have values though?, that is why you are using them?
If it was just the same values all the time, only then could you hardcode it as you have done. Even then you would use the actual values and not the controls.

[CJ_London]

just to add to WGM's comments, you would still need the text delimiters even if the values were hard coded because the fields you are applying the criteria to are text

=DLookUp("Mobile","tblDealers","[PostCode] = 'ab12 3wq' And [Name] = 'george'")

[DMT Dave]

Hi Guys thank you, yes just needed the text delimiters in, unsure why i didn't think of that one!!