Search results

FYI--I used 'MsgBox sfrmNeighbors.Name' to see what form I'm actually on and it's the Neighbors subform which is where all of my fields are--not sure why my field PKRelationship isn't being recognized.

Sorry, fried brain. I made the corrections. I don't see an embarrassed emoji! That would go here.

Hi Dave, Thanks for hanging in there with me. Yes, my subform control and subform have the same name. I've shortened it to 'Family' rather than 'Family Subform'. And yes, I am trying to reference the subform Neighbors that is a control on the subform Family that is a control on the form...

I think this article, http://btabdevelopment.com/easy-way-to-remember-how-to-refer-to-subforms/, gets me closer to the solution. I'm still trying to get it to work. Now I'm getting error messages that my fields aren't being recognized.

Hi Dave, The article makes sense if I'm directly referencing the controls but since I'm defining them as objects (I know there's a better term for this), I don't really know how to apply it. I would think I could substitute my variable names into the reference string. Since frmNeighborhood is...

Hi All, This worked: Dim frmNeighborhood As Form Dim sfrmNeighbors As Control Set frmNeighborhood = Forms("Copy of Neighborhood Input Form") Set sfrmNeighbors = frmNeighborhood![Neighbors] This doesn't: Dim frmNeighborhood As Form Dim sfrmFamily As Control Dim sfrmNeighbors As Control Set...

It sounds like a good plan. However, I'm trying to retrofit an existing db. If I make the Family a master to the People, I have a whole lot of rewriting to do in the code. At the rate I'm going now, it might be better to scrap all the forms and start over.

Hi Ranman, I already have FK FamilyID in tblPeople and FK AddressID in tblFamily. The master/child on the Family Subform is AddressID linked to the master form, Neighborhood Input Form. "master table tFAMILY , add all people from the tPeople in a subform to assign FamilyID to each person."...

Hello All, I've attached my db. My main form is Neighborhood Input Form. On that form I have subforms. There is one, Family subform, I've recently added and can't seem to get it to work how I want. Let me start from the beginning Original design: one family per address New design...

No, my form is set on form view. I did import my tables into my test db and it works again--so now I'm scratching my head since I don't know where the problem exists and what I've added since the last time I posted the db to the forum.

I posted another issue, then realized I've got bigger problems. My form isn't showing all of the results of the underlying query. It used to show all people living at an address and now I'm only getting the first person. The query is correct, the form isn't. I've removed all event procedures...

I apologize for the really late response, I was working on another project and now I've forgotten what changes I had made. I'm going to import the forms from the db I had posted in another post and start over.

Hi All, Evidently I was trying to "improve" the look and security of my subform and I've changed something -- I don't know what. Now, I've set myself back when trying to get things working. I've attached a screen shot so you can see my form. The upper right subform is the Family subform...

@MarkK I've never used the split function so I'll give that a try. I'll also implement the dbFailonError on my current code and see if that raises anything.

@jdraw When I use the debug.print, this is what I see: sqlstr1 = "DELETE * FROM tblFamily WHERE PeopleID = 2495" Then I execute. So, this is new to me. People ID = 2495 has been deleted from tblFamily but the remainder of the record is still there, only the PeopleID is gone. Is that...

Identifier is being passed through the function as string.

Sorry, I thought I made it clear that I did step through my code and evaluate the variables. Everything seems proper. What is "&x&" when it should be "x"??? I did run through the code again with the break point and tblFamily did not execute.

Hi All, I've been using this code for years without problems (or so I think). I've added another table to my array and incremented my variable. When I step through the module, sqlstr returns a rec for tblFamily but the delete statement doesn't delete the record. I've copied both sqlstr and...

My third record overwrote my first one.

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?