Hello all,
I'm in desperate need. I have a form with two subforms (Material and Hardware). The Material and Hardware subforms both have an unbound text box in the form footer with a default value of 0 that calculates all of the POAmounts. I then use those values in another text box calculation on the main form. However, when there are no records in the Material or Hardware subforms, the default value of 0 doesn't display and this results in an error on my main form.
How can I get the Material and Hardware subform total text boxes to always display a 0, even if there are no records in the subform?
Any help is greatly appreciated.
Margaret
Bookmarks