#Error message

[jerry28ph]

hi all,

I have a report and a form, wherein i just grab the value of the report (say Total of a field as Total_Ded) and put it in the textbox by means of
Control Source = =Reports![Total Deduction Report]!Text14. The value of text14 will be store in another form. If the the value is 0 or null, after I ran the form, it gave me "#Error" (because of the value 0). If the value is 0 then "0" will put in the text box. Is there additional criteria or condition for this issue.

Thanks and more power.

REgards,
Jerry

 

[Rabbie]

Total DeductionReport needs to be open when you try to access a valu on it.