If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using Tab Controls
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 |
#2
|
|||
|
|||
Using Tab Controls
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. -- hth Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "tv" wrote in message ... 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 |
#3
|
|||
|
|||
Using Tab Controls
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 tv wrote: 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 |
Thread Tools | |
Display Modes | |
|
|