Calculating Sum on Main Frm from 3 Subforms

J

jmc8355

I have frmTimeCard(Main) and 3 subforms frmPTS, frmPJTS, frmITS. All 3 of
these forms capture hours for differant activites that employees can be
invovled in. These forms are on tab controls. I have sum control in each
subform's footer and referance them on the main form. That works great. Now I
what to total these three controls on the main form and I have achieved this
but only when each sum control is populate. If employee does not get hours in
all three subforms then the total does not appear.

Let's say employee gets hours in frmPTS but not frmPJTS or frmITS when I
scroll to that record the Total will show up for about a second and then
disappear untill employee gets hours in the other two subforms. Any thoughts?
 
T

tina

suggest you read up on the Nz() function in Help to see if it will work for
you in this situation.

hth
 

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

Correct Nz syntax when summing? 4
Filtering subforms via main form 2
Sum in Main Form from Subform 7
Retrieve a value from an unbound control on a subform 4
Sum in Subform Not Showing Up in Main Form 4
Summing the value of calculated control on subform to a main form 2
Subforms not picking up the date from main form Access 02/03 3
Main form with subforms 3

Top