I have a text box on a form with the control source tied to the value of a field from a datasheet embedded as a subform on my main form.
textbox.controlsource = EA_Subform.Form![Exhibit_#]
Everything works fine until the subform which holds the Exhibit_# doesn't have any records returned.
When this happens, the value in the textbox is now #Error.
Is there an IIF statment I could put in the control source of the textbox which would set the text box value to "" if there are no records returned in the subform?