Subform not populating

[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.

I checked the master/child links in the form and they are correctly mapped.

Any help would be greatly appreciated.
Thanks!.

 

[vbaInet]

What about the FilterOn and Filter properties?

 

[Caddie]

of which form? The parent or children?

 

[Caddie]

The settings on the data tab of each form are:
Filter Filter on Load
blank No
blank No

 

[vbaInet]

Of the child? Try counting the RecordsetClone property of the immediate subform as well. If the immediate child is showing the right record it should cascade down, so only concentrate on that for now.

 

[Caddie]

Those are the filter settings for the main form and the sub forms. Sorry, but what do you mean by "Try counting the RecordsetClone property".

 

[vbaInet]

dim rst as dao.recordset
set rst = me.redordsetclone
msgbox rst.count

That's what I meant (for the subform). Try that after save or on Current.

Is there any piece of code that sets the values of your controls in your subform?

 

[Caddie]

Just go it sorted...SOS helped me. it was the type of join I had to one of the tables in the query. Needed it to be a left join.

Thanks.

 

[vbaInet]

Excellent. Glad you got some help.