subform and tab control

[darrask]

I have a form, containing 3 tab controls, 2 have a subform, which is itself containing a subform.

I had it perfectly working, but since I inserted the subforms in tab controls, I get the error message 2335 4 times (4 subforms in all) every time the form is opened:

I definitely have the same number of fields in child and parent forms.

Anyone has an idea? I can upload a sample of my base.

 

[The_Doc_Man]

It is possible to use a compound key for parent/child forms. When that happens, you specify the fields as a comma-separated list in those two properties of the sub-form control. The same number of fields must be used for parent and for child, and further those fields must match in type. I think the child form ALSO requires that the fields you named be spelled correctly and correspond to fields in the recordsource of the child form.

Your message says Access sees a different number of fields between those two properties. Check your punctuation in the sub-form's property dialog box to see if you missed or added a comma somewhere. Also verify spelling of the child-form link fields against the names in the recordsource of the sub form.

 

[darrask]

Thank you for your information.
I had only 1 parent field to link with one child field, so this is free of errors.

However, in the meantime, I just remade all the forms and subforms (and I can tell you the result is the same) and the error messages don't appear anymore. I've had this a number of times with access, somehow some trash can't get lost of forms and reports which have been modified a lot, causing errors.