Text Box Calculation Default Value Even if No Records Exists

[PSSMargaret]

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

[Greg M]

Hi there,

It's difficult to be precise about this without access to your UserForm(s), but one solution might be to check the value of the unbound TextBox immediately before the UserForm is closed (e.g. via an OK button) and to have your code insert a value of zero if the TextBox is empty.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[PSSMargaret]

Greg,

Thanks for taking the time to help me. After many hours of research, I ended up adding =IIf(IsError in their to the text box calculations on the main form. It was a bear.

Margaret

[Greg M]

Hi again Margaret,

Thanks for the feedback - glad to hear you've got things sorted out at this stage.

Regards,

Greg M