How to Get Two Datasheet Sub Forms to Work With Each Other

[doyle60]

I have an unbound main form with two datasheet sub forms:

SelfPrintNewCatPrintsub (Datasheet sub)
SelfPrintNewGrpPrintsub (Datasheet sub)

SelfPrintNewfrm (Main form in form view)

The first sub form is really the header of the second subform. When a
record has got the focus in the first, I want the second to filter to
only those matching records.

Here are the fields in the first sub:

CategoryID
CategoryNumber
CategoryName

And here are the fields in the second sub:

CategoryID
GroupID
GroupNumber
GroupName

So the link is CategoryID.

So what code do I use? Where do I put it?
I've been trying to adapt code created by the wizard and changing the
property. But no go.

If need be, the main form is unbound, but I can "Bind" it if necessary.
There is no relationship created in the relationship window at the
moment.

Thanks,

Matt

 

[doyle60]

I'm going to withdraw this question for the time being. Though the
answer may be helpful at some other time.

I'm going to rethink my form for another reason, that is, not because I
can't figure this out.

Thanks,

Matt