Access (2000 V 9) only allowing one sub form on a form's tab control

[michaellysons]

Hi

I have a form that contains a tab control. There are a number of pages on this control, with each page containing a sub form.

Here's an example:

Form1 has a tab control called Tab1.
Tab1 has three pages: Page1, Page2, Page3.
Page1 contains SubForm1 - this subform was added first.
Page2 contains SubForm2.
Page3 contains SubForm3.

The pages all contain the correct sub forms; I've checked this in Form view.

The problem occurs when I save Form1. Access then sets the subforms on pages 2 and 3 to be SubForm1, i.e. the subform that was added first. I end up with;
Page1 contains SubForm1.
Page2 contains SubForm1.
Page3 contains SubForm1.

I have tried compact and repair on the database and that did not work. I tried building a new database (rather than editing the existing one) and the same problem occurred.

I've also looked at other databases I have created that have subforms on different pages of a tab control. Rather nervously I tried saving the forms, but Access did not reset the subforms. Phew...

Any ideas as to why this is happening?

Thanks

Michael

 

[michaellysons]

I've solved it now.

In my Access databases I have a form called frmTemplate, which not surprisingly I use as the template for all forms. I decided to delete it from my database along with the offending main and sub forms. I then recreated the main and sub forms. And lo and behold it all works more funkily than Jay K on the dancefloor.

I've no idea why it worked, mind.

 

[michaellysons]

The subforms were being added to the tab control correctly; I checked that in the form view. I'm still no wiser as to why Access saw fit to reset the subforms though. But it works now, so I'll stop losing sleep over it.