I use a dlookup function on a text box to get a report description of the report listed in a combo box. It looks like this.
Code:
=DLookUp("[Notes]","tbl_AccessObjects","Object_ID = [cboReport]")
It works fine, unless the combo box is not populated yet in which case I get and #Error. So I put in some error checking which looks like this.
Code:
=IIf(IsError(DLookUp("[Notes]","tbl_AccessObjects","Object_ID = [cboReport]")),"",DLookUp("[Notes]","tbl_AccessObjects","Object_ID = [cboReport]"))
)
This has no effect at all. It works when the combo box is populated, gives #Error when it isn't.