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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Another kind of (field) population? 2
subform totals to popform 1
Display msg when value chgs to zero. 6
Parent.RecordSource in a popup 4
tabcontrol page caption 1
Creating a filter box for fields in a subform 3
remembering the amount 3
creating a filter textboxes for a subform 5

Back
Top