Calculations in SubForms

[Chip]

I have built some Subforms that are functioning properly
except that if I add a new Record to the Master form the
calculations show "#Error" until data is entered into the
calulated fields of the subforms. Is there any way to
keep that Error from printing on the text boxes until data
is entered? I am really new to Forms and VB so please be
gentle, and THANKS IN ADVANCE!!!!

 

[Wayne Morgan]

In the calculated field, add another item to tell the calculation what to
return if there isn't a value. There are two functions usually used to do
this, IIf and Nz.

Example:
=Nz(txtOtherTextbox + 4, "")
or
=IIf(IsNull(txtOtherTextBox), "", txtOtherTextBox + 4)