Hi

I built a form using tab control pages. In the form properties for a record 

source I selected fields from two different tables. Now my problem is when I 

want to input a new data into the CustomerId, which is a primary key for 

both tables, it changes for me automatically all CustomerId in one of the 

table, where the CustomerId is the combo box based on the CustomerID from 

the first table (Customer Details). This means instead of having different 

details for different customers I have different details for this same 

customer. It is really strange, but I have to do something wrong, but I 

REALLY DON?T KNOW WHAT? Please help.

Another my question is how can I separate each of the tab pages. Instead of 

selecting all fields from tables and queries which I will need to use for 

each of the tab together. I would like to have different record source for 

each of my tabs control pages?

Many thanks

Jola

Hello,



I'm not sure I totally understand what is going on with the first problem 

because I don't know the table structure you're using.  Are the tables 

linked by the CustomerID?  Is it a one to many relationship or a one to 

one relationship?



I can make a couple of suggestions...It is always best to use a simple 

recordset for a form (i.e. one table).  If you need info from another 

table that has a many-to-one relationship to the main table, use a subform.



You can also create subforms and place them on your tab control pages 

because you cannot create a new recordsource for each page.  Link each of 

your subforms to the main form.  But be careful, too many subforms can 

really slow the performance.



I hope that this helps.

Claudine