Tabbed Page Problems

[LadyDi]

I am trying to use tabbed pages on a form. This database has two sections (one based on contracts and one based on discounts) connected by a customer table. I would like to be able to enter the Customer name in the header of the form and then be able to see the contract information for that customer on one tab and the discount information for the same customer on the second tab. I put subforms on the two different tabs, however, the problem that I am having occurs when I try to enter a new customer. When I type the new customer name in the "customer name" field, it overwrites the customer name in the two subforms, instead of beginning a new record. Is there a way to make this work?

 

[thunder]

in northwind database sample you will find that the employee form is a tabed one and what you are asking for is in it.
to open it go to Help then go to Sample databases

 

[LadyDi]

I looked at the first sample database and none of those forms have tabbed pages. I could not open the second sample database because SQL server is not loaded on my computer.

 

[CEH]

Doesn't sound like the problem is with the tabs, sounds like it is a problem with the relationship of the subform to the main form. Mainform Customer name? CustomerID? Is the subform linked via CustomerID? Or linked via whatever your primary key in the mainform is...

 

[LadyDi]

I have an autonumber assigned to each customer in the customer table. Then I included the autonumber on each of the tables. The pages are linked on the autonumber.

 

[CEH]

If the Master child is on the CustomerID... The only thing that comes to mind, is it is not moving to a new record before you enter data....

 

[LadyDi]

Oh, I see. Changing the customer name doesn't mean that the database will automatically go to a new record. I thought when I changed the customer name, the autonumber would change therefore taking me to a new record.