Search results

Hi Mark, The master/child link between frmAddress and frmFamily (subform) is the AddressID, so why isn't the AddressID being recorded in tblFamily? qryFamily is the underlying query to frmFamily and it contains tblAddress, tblFamily, and tblPeople. AddressID is the PK in tblAddress and FK in...

Hi Mark, Thanks for the forms. Your solution is elegant but will take me longer to look up information. When a phone number or email address is requested, I will need to drill down to the third screen to retrieve the info. I see you caught one of my errors by having the check boxes at the...

Hi Mark, I have ControlsVisible() working. I'll send it to you in a PM. Thanks

I'm not sure how to pick up an attachment someone else posted. Cronk created this graphic for me, http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=62303&d=1459125196. It shows the relationships between the tables and I think it accurately reflects my relationships set in...

I've attached my db. My current design will open (Copy of Neighborhood Input Form). My last design is Neighborhood Input Form. I've made a few changes to get the "Copy…" to work but I can change them back then upload again. Let me know. Thank you!

So still pondering… I've attached my previous design. Do you see a problem if I make the Family subform a datasheet (Address form/ Family subform) and make the People subform (Address form/People subform) unbound? The problem I was running into with this design, I had both subforms bound...

Hi Mark, Thanks for responding. So I would build a main/subform for Address to Family, then a main Family form, with a People subform? I know my main Address to People subform works, that's been my design for the last 20 years. It would make my life easier breaking this down, I've been...

Hi All, I've been stuck on this for days and I'm still stuck. :banghead: I have a main form (Neighborhood). Within it I have a subform (Family)--master/child link AddressID, within Family I have a subform People, master/child FamilyID. I need the Family subform to display a list of families...

Hi Cronk, Thanks for the graphic. It looks like the relationships I have set in my queries. There's no reason to keep families when they leave the neighborhood. These are actual houses that are being bought and sold. It's possible someone might move back to the neighborhood, but it hasn't...

Hi J, From the top down for the hierarchy based on a neighborhood: There is a unique address in the neighborhood, the neighborhood is built out so there will not be any new addresses. There can be more than one family living at the address (but not at other addresses). There can be more than...

I've got 9 tables plus the underlying queries for the forms, subforms, and combo boxes. I'v attached my db. I have tried using a datasheet outside of the subform but I wasn't able to pass the FKs to tblFamily (Neighborhood Input Form). I'm currently working with Copy of Neighborhood Input...

Wouldn't it be easier for me to attach my test db? The data is already made up.

Hi CJ, I apologize, I thought I'd given the info requested since the db wasn't requested. I've attached the screen shot and the underlying query for the Neighbors (People) subform. I have no relationships defined among the tables but I've included the primary tables. For the user, I want to...

Hi Mark, I keep the records for the HOA of two neighborhoods. The records are used for the neighborhood directory, distribution of the neighborhood newsletter which includes announcing children's milestones (with their parents permission), and also teen jobs. The records are also used for the...

Hi CJ, I'm still having trouble w my list box. I revisited your earlier post and have a question. Is the sub-subform located in the datasheet subform? Since a datasheet can't have a subform, I'm assuming it's off to the side and set with a a master/child link to the unbound text box. If...

Hi CJ, I'm using Access 2007. I've attached the screen shot of my nested forms. I have a db of a neighborhood--so the address drives the db. Usually one family lives at the address but recently I have multiple families at the same address. My new form should show the address, the families...

Hi CJ, If I understand your last paragraph correctly, the datasheet (subform) would be driving the main and sub-subform. The Main form needs to be the driver of everything. The main form is the address and the address is at the top of the hierarchy. If I've misunderstood, would you please...

Hi CJ, I can't get my head around this. My main form is for the Address. It links to the Family subform on AddressID. The Family subform links to the People sub-subform on FamilyID. If I make my main form unbound, how do I get my AddressID to link to the subform? I'm sure you've figured...

??? Sorry CJ, it's already past wine o'clock here and I'm a little lost with your very elegant solution. I'm going to have to break it down. The unbound main form and unbound text control are throwing me off. I'll give it a go and let you know. Thanks!

Evidently having my subform set to datasheet prevents my sub-subform (single form) from showing. Not sure why.