Value from Nested Subform

M

Melinda

Hello,
I have a nested subform that I'm using in the datasheet view. I would like
to display a value from the lower subform on the higher one, for example,
display my Total Number of Jobs on my higher form next to all of my other
data about the job. So, I've set a textbox on my higher form to
=[frmSubSub]![ControlName]. The only problem is that this textbox displays
#Error until I expand the lower subform. After I do this the textbox will
show the appropriate value. Any ideas on how to tell it to pull the data
automatically?
Thanks!
Melinda
 
Top