Dee,
You set the record source of the datasheet view of the subform to a query
that has as it's criteria the record id of the record you want to show.
This can be done by referencing a control containing that id. You can
reference it by right clicking in the query criteria cell of the record id
column and selecting build. Then find the subform and then the control
containing the record id value. Have the event you currently have simple set
the record source of the subform to the query mentioned above.
bob
>I am running this event from a control on a sub-form that refers to another
>sub-form. (I have a main form, subform and subform)
[quoted text clipped - 26 lines]
>
>Any help would be great!

Signature
Bob Heifler
My Access Program, Owner
www.myaccessprogram.com
info (At) MyAccessProgram (Dot) com
dee - 10 Nov 2007 00:07 GMT
Thanks so much for your response. I came up with another solution, but will
try this out over the weekend for future reference.

Signature
Thanks!
Dee
> Dee,
> You set the record source of the datasheet view of the subform to a query
[quoted text clipped - 36 lines]
> >
> >Any help would be great!