A little more information...
My text box is pulling data through from a sub report and currently has the following code in its control source:
(subreport name is in bold italic)
- =[Forms]![frmDistLearnByStudMain]![frmDistLearnByStudCalculatePrevSessTotalHours]![txtDuration]
I am receiving the #Error when the sub report contains no data.
I have done some research and have discovered that i need to incorporate the HasData property into an IIF statement but am really struggling with the syntax.
Can anyone help me please?