Linking Subforms

[painterz]

That one I resolved with the sfrmPeopleID text box on the main form. I'm using it as a link between the family and people (Neighbors) subform. There was a posting on 7/30/10 with a similar problem and this was vbaInet's solution. I wasn't sure why you wanted the db.

 

[painterz]

Maybe you can explain to me why my PeopleID won't write to tblNotes and PeopleID and FamilyID won't write to tblPhone. I know this is a newbie issue but I can't figure it out.

 

[painterz]

Hey Paul, I don't think my problem is resolved after all. I tried adding three people to the same address, all designated as "primary", and it turned into a mess. I added the people in the Neighbors subform (people) not in the Family subform. Any ideas?

 

[painterz]

My third record overwrote my first one.