Calculated Fields 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 have tried using the "nz(variable,"")
function with no success. The subform query that the data
is reading does not have a record to read and this is
causing the "#Error". Again the functionality works
correctly, just the error message that is in the fields of
the calculated fields is confusing the users, making them
think that something is wrong. I am really new to Forms
and VB so please be gentle, and THANKS IN ADVANCE!!!!
 
This type of question is usually hard to answer if you don't supply a
sample of the calc that fails. But often you can avoid an entire set of
such headaches by performing your calcs in the query that underlies the
form, rather than on the form itself.
 
Back
Top