Subform Subform Help

[gmc2k2]

Hi,

I have a main form where it has a subform linked by a reference number which displays in a datasheet view, then when you doubleclick the record in the subform, it opens up in more detailed version of the same subform on a form which also has a subform linked by the same reference number so technically a nested subform which is also a datasheet form. (so a Main Form>Subform>Subform

what im trying to do is display on the main form an unbound text box where it counts from the subform's subform if it there are an records which have "yes"

if that makes sense, i can do this in the more detailed subform by using =Sum(IIf([Product]="Yes",1,0)) but can't seem to work it from the main form?

any help would be appreciated

 

[gmc2k2]

thanks for this AccessBlaster when i get back this evening i'll start with what you've said.

really appreciated