Unbound Textbox (#Error) Message When No Data

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

I have several unbound textboxes that calculate totals, etc... I would like
to be able to supress this error message when there is no data.
#Error. Can I do this, and if so how ?


Thanks,


Dave
 
If new records cannot be added to this subform, try:
=IIf([Vendor List].[Form].[RecordsetClone].[RecordCount]=0, 0, [Vendor
List].[Form]![Amount])

If they can, you can probably use:
=Nz([Vendor List].[Form]![Amount], 0)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to the newsgroup. (Email address has spurious "_SpamTrap")
Dave Elliott said:
These Text Boxes calculate a total for a Profit Loss form.
Vendor List calculates off a form the Total of the Vender Amount
Employee Time calculates the Gross Wages paid to the Employees on that job.
It then subtracts the differenve between then and returns a Profit or Loss
calculation.
The problem is that sometimes there is no data for some of the fields that
they refer to, therfore showing a #Error message.
This is what I want not to show up if there is no data for that text field.
Hope this explains it better.

Thanks,

Dave

=[Vendor List].Form!Amount
=[Employee Time].Form!GrossPay
=[text170]-[text172]-[text174]


Dave Elliott said:
I have several unbound textboxes that calculate totals, etc... I would like
to be able to supress this error message when there is no data.
#Error. Can I do this, and if so how ?


Thanks,


Dave
Click to expand...
Click to expand...
 
Back
Top