multiple tab controls within each other.

[ahvc]

Hello,
This is my frist post here.

I am using a couple of forms. I put tab controls on both of them. When the user clicks on the first tab in the main form, I wanted them to have access to the subform, which also has a tab control. The second and other tab in the main form will have data from other tables, but I have not yet implemented them. Both the forms have the same datasource table.

The subform within works fine if I test it alone, but when I open the main form, I see only one record within the form within. (even though there are more than one record). As I said, if I just open the form within seperately, it tests fine. If I try to add a record to the form within , when that form is within the main form, I get this error:

Microsoft Access : You can't assign a value to this object.

The object may be a control on a read-only form.
The object may be on a form that is open in Design view.
The value maybe too large for this field.

As far as I can see, the problem is not related to these. Can someone throw some light for me.

In access, is there limitations to use tab controls within another?

Thanks
VC

 

[ahvc]

what if different subform use different tables?

Thank you for that.

I tried that, but then the problem is I have more than one form in the tabs within, and they need to use different tables. These tables are not related to each other necessarily. So what is the sourcecontrol for the main form?

I tried using no sourcecontrol table for the main form, but then it does not work at all for the subform , anything..

any help will be greatly appreciated.
thanks
vc.