Subform issue

[Caddie]

Hi All -

I've got a main form, which has a subform. This subform has a subform and that subform has a subform. i had it all working perfectly, however I must have messed something up because now when I enter data into the form (the parent and each of the children) it works I can save it, if I look in the table the data is there and all properly linked, but when I go back and view the information in the form all I get is the parent information the data in the subforms do not appear. I know it's there though because one of the fields in one of the subforms must be a unique value and if I try to enter a new record in the form using this value it doesn't let me not to mention the fact that like I said previously I can see the data is linked in the db.

Please help ASAP because this is a contract management tool and we have temps coming in tomorrow to start enter the data.

Thanks!.

 

[llkhoutx]

First: Forms can only be nested 3 deep. A subsubsub forms must be requeried on its parent's OnCurrent event.

Second: I think that the Master/Child link properties of the descendants of you main form are probably Null or incorrect.

Third: Do not create a record in a descendant subform without all ancestors being populated, otherwise you'll create an orphan record, i.e. a record with no parent.

 

[Caddie]

1 - It was working so I think I should be able to get it back to where it was.

2 - Where do I check the Master/Child link properties?

3 - The way the form is set up you can't enter data in a child form until the parent is completed.

 

[Caddie]

i checked the links and they look right. One other thing, I replaced one of the tables i the backend, but used the exact same naming and field types. And again, I've gotta say, why would the data be storing properly in the backend still if there was an issue with the links?

Thanks.

 

[SOS]

First: Forms can only be nested 3 deep. A subsubsub forms must be requeried on its parent's OnCurrent event.

No, subforms can be SEVEN (7) layers deep.

And, if they are linked using the Master/Child links you do NOT have to requery them.

 

[Caddie]

Just to be clear:

Main - Customer Info
Sub - Contract Details
Sub - Service Address Details
Sub - Service Details

The form was working fine before.

 

[SOS]

Can you upload a copy of the database so we can look? I do a lot better (and faster) if I can see it.

 

[Caddie]

how can I do it if it is a split protected database?

 

[SOS]

how can I do it if it is a split protected database?

Well, you could upload each part of the database and the MDW file.

You'll need to zip each part SEPARATELY (make sure you run compact and repair first).

 

[Caddie]

I'd like to but I better not because it's branded with my company logo, not to mention our customer information.

 

[SOS]

Well, if you want to solve your problem quickly because you have people waiting, then you'll need to do something (clear out the customer data and put in a bogus record or two).

And if you don't feel comfortable posting it here, you can email it to me (make sure to zip it all). I'll PM you an email address.

 

[Caddie]

I'm going to ask IT to restore the file to where it was yesterday (when it was working) asuming they can then I will just have to take some time tomorrow to make my changes again, if not then I will send you a message tomorrow to see if you can help.....if you don't mind that is.

thanks a lot.

 

[SOS]

The problem is that you are not really pulling the previous information. By selecting the combo you are just trying to pull existing information. Also, if there isn't a PDF for each record then your recordset with a one to one link is not going to pull anything for that subform. You need to change it to an outer join in the underlying query so it will pull the record even if a PDF file does not exist.

Your Customer # combo box should be bound to the customer ID field and then you should have ANOTHER unbound combo in the HEADER to search for a customer. Also, you should get rid of special characters in names (no using # in them).

 

[Caddie]

YOU ARE THE CHAMP!

Perfect, changed the join type to LEFT join on the subform and BINGO!

Thanks so much Brian.

 

[SOS]

No problem. Glad we could help.