Intermittent #ERROR on unbound control

[Sketchin]

Hi,

I am getting an intermittent #error on an unbound textbox on my main form. The control source of this textbox is this:
=1000*Round(DSum("[IndustryLeaseRate]","UniqryFiscalUsageToDateDashboardnew")/1000,0)

Is there something wrong with this equation? Its just simply summing a column from a union query.

To explain further, this control is on my main menu and it pops up when the database opens. It seems that everytime it opens for the first time, I get the error. If I close the form and re-open it, it seems to go away.

Thanks for any and all suggestions!

 

[gemma-the-husky]

only thing i can think is the dsum returns a null set, giving you a value of null, not zero. that might produce an error

 

[Sketchin]

I put in a NZ and it seemed to work. Not sure how I never thought of that! Thanks for the advice!