Problem:TAB CONTROL

[phatus]

good day!
i have a problem in my database
i created 2 table namely
tblrecord and tblenrol and in my form i created a TAB CONTROL
page 1 is Record (source is tblrecord)
page2 is Enrolment (source is tblenrol)

i use FORM DESIGN MODE and click Add Existing Field

i drag and drop the tblrecord fields in page1
when i go in page2 when i tried to drag and drop the tblenrol fields a specify relationship appear... i tried to connect it but my problem is i cant edit the data nor add in page 2...

what i want is page2 must be editable so that i can record the enrolment...

attached here is sample of may database pls take a look at it..

 

[John Big Booty]

Tab controls on a form, area really only a way of increasing your form real estate for a give sized form. So all tabs are linked to the same Record Source. To have tabs feeding different Record Sources you will need to use a Sub-Form on one or even both of your tabs.

 

[phatus]

i found a way i use relationship... thanx