Hi there. I have a form which uses some text boxes to display the latest date as derived from a field elsewhere in the form. However, when the form is first opened (and displays a blank record), they display #Error, presumably because they're trying to work out a calculation for an empty record. Is there any way of making the text boxes not display the #Error thing?
For example by the way, one of the text boxes is called Text44 and its control source is:
=(Nz(DMax("[DateCompletedAnnual]","tblAnnual","IDClient= " & [IDClient])))