Forms and tab controls and tables

I am using Microsoft Access 97. I have created a form with a tab control. On it I have added six pages. These six pages each link to six tables. However, at run time, I am unable to click on the first page and enter data to go into the first table and then click on the second page and link to enter data into the second table. How can I do this? I have tried on the click event but with no success. I am reluctant to use sub forms (unless absolutely necessary). Please could you tell me what to do so that I do not have to put all the fields into one big table.

The data can be in different tables, but the query upon which your form is
based, needs to contain all the fields and tables so you can update it.

Rick B


"King FSST" wrote in message
news I am using Microsoft Access 97. I have created a form with a tab control. On
it I have added six pages. These six pages each link to six tables. However,
at run time, I am unable to click on the first page and enter data to go
into the first table and then click on the second page and link to enter
data into the second table. How can I do this? I have tried on the click
event but with no success. I am reluctant to use sub forms (unless
absolutely necessary). Please could you tell me what to do so that I do not
have to put all the fields into one big table.

King,
You need to back up a step. When you say the six pages each link to six
tables, how have you done that? Tab pages don't have recordsources. You will
probably have to use a subform on each tab page if you are working with
independent tables.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"King FSST" wrote in message
news
I am using Microsoft Access 97. I have created a form with a tab control.
On it I have added six pages. These six pages each link to six tables.
However, at run time, I am unable to click on the first page and enter data
to go into the first table and then click on the second page and link to
enter data into the second table. How can I do this? I have tried on the
click event but with no success. I am reluctant to use sub forms (unless
absolutely necessary). Please could you tell me what to do so that I do not
have to put all the fields into one big table.