Text box calculation vanishes

  • Thread starter Thread starter MsDYJ
  • Start date Start date
M

MsDYJ

I have an unbound text box in a mainform that totals calculations from 2
mainforms. The code I put in the control source works fine, but when I open
up the form the amount shows and then quickly disappears. I have the control
set to being visible but I don't know why it's doing that. Any suggestions?

Thanks
 
Here's the code:
=[Forms]![frmProject]![sbfResources]![ResourceSum]+[Forms]![frmProject]![sbfMaterials]![MaterialsSum]
 
Here's the code:
=[Forms]![frmProject]![sbfResources]![ResourceSum]+[Forms]![frmProject]![sbfMaterials]![MaterialsSum]

PieterLinden via AccessMonster.com said:
Very hard to tell without seeing your code.
Click to expand...
Click to expand...

Might either of these controls be NULL? If so you'll get a NULL result. Try

=NZ([Forms]![frmProject]![sbfResources]![ResourceSum])+NZ([Forms]![frmProject]![sbfMaterials]![MaterialsSum])
 
Back
Top