Calculations in SubForms

  • Thread starter Thread starter Chip
  • Start date Start date
C

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!!!!
 
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)
 
Back
Top