Make #Error go away

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I have a form with a subform.

A textbox on the form takes subform.totalpaid and
subtracts it from [amountdue]. This works fine except
when a customer hasn't made a payment, then the textbox
gives you #Error (because there is no value in the
subform).

I have been trying to blank out the #Error through
various methods, without success.

I have tried "iif"s within the text box control source.
I've tried VB code on the form itself (such as trying to
use "hasdata" to set visible property for the text box).

The textbox control source doesn't like "hasdata"
and "null" doesn't cover this situation.

Ideas?
 
Back
Top