getting #Error in text box on report 1

[DougP]

Can I use something like this, so it shows a blank instead

=IIf(IsNull(DLookUp("Description","Parts2","PC=" & [PC])),"",DLookUp("Description","Parts2","PC=" & [PC]))

The Dlookup works fine it there is something to look up but some columns are blank
it still shows #error
what am I missing

DougP, MCP, A+

 

[Remou]

Do you mean:
=IIf(IsNull([PC]),"",DLookUp("Description","Parts2","PC=" & [PC]))

 

[Remou]

Weel, that's what comes of posting without previewing

=IIf(IsNull([PCs]),"",DLookUp("Description","Parts2","PC=" & [PCs]))

As typing all those brackets is a bore, read PC for PCs.

 

[DougP]

yeper
thanks

DougP, MCP, A+