I have an unbound text in a form to calculate the sum of a subform. The subform is based on a query. When the query shows no records I get an error in the unbound text. How can I avoid the error and show zero instead?
I have tried several ways to do it including the tutorial in http://allenbrowne.com/RecordCountError.html but it seems that nothing works. Any suggestions?