Using Tab Controls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to admit, I have zero experience with using tab controls.

Here is the issue. The main form has the basic detail of the project. Then
there are 3 tabs which provide different details of the project. The main
form feeds a table and the 3 tabs feed tables. Auto number is set up which
is used to link each of these for later reporting.

The problem is that when a new project is added, the tabs due not auto
number in sync with the main form.

How can I get the tabs forms to update the auto number in sync with the main
form?

thanks
 
TV,
The 3 Tab forms should be subforms that conatain the Many data that relates to the One
on the main form.
One customer... many orders, One Class... many students, etc.
There should be a realtionship between the One main table and each of the Many subform
tables. On your form design, you must also indicate to Access which field relates the
main tothe sub... via the Parent/Child properties. For ex. a CustId or a StudentID.
When a new record is entered in any of the related subforms, the key field will
automatically be entered to match the main form's key field value.
 
The three tables (on the tabs) related to the main table should not be
autonumbered. If the relationship between the main table and each of
the three other tables is one-to-one, you can make theit ID field
default to the ID field on the main form. In the subform use
=me.parent![project_ID] in the default property.

Just as a note, your tab control is not the source of the problem. You
you would have to deal with any sub-form the same way in your case.

John
 
Back
Top