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

  • Thread starter Thread starter mewins
  • Start date Start date
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!
 
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
 
Back
Top