Find data through subform (1 Viewer)

[jneirinckx]

Good morning,

I have a Main form that contains Name, Address etc.. then a subform which contains the activity with this person. The subform has a description field and what I would like some help or suggestions with is how to search for a word in this field not only in the this persons record but all subform records so that we find which record this particular word belongs to. Something like opening the subData table and searching there.

Is this possible.

Thank you

Jerry

 

[Oldsoftboss]

Hope you can gleen something from this.....

Dave