Attaching subform(Datasheet) to a subform(Single Form)

M

mewins

I have master client info form with several subforms. I want my subform
"subfrmRecCont" (client case notes, set to single form view) to have a
subform of its own, "subfrmRecAct" (which i need to have as a datasheet
view). Right now, subfrmRecCont links to my master client info form via the
ClientID and that works fine. How do I set up the subforms so that for any
given subfrmRecCont I can see the specific data listed in subfrmRecAct? Both
forms contain the ClientID, but I realize I will need to link them somehow
differently. As of right now, I don't have anything linking a particular
record for subfrmRecCont to subfrmRecAct. Any ideas? Thanks!
 
J

Jeff Boyce

From your description, your second subform would need both the ClientID AND
the primary key of the first subform.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top