Using Tabs with Subforms

[Guest]

Hi,
I have a form with Tabs on it. On each tab I put a subform.
All the subforms were created from the same table. It was
a big table and I wanted to split it up.
I put a QID on each subform. QID is question ID field.
Each subform looks at a JOB ID from another tabel.
I was hoping that when they were finished filling out the 5 subforms
it would go to ONE record in the table with one common QID.
I am getting it all in one table but as 5 records with 5 different QID's.
They do all go under the correct JOBID though which is generated by the other
table.
Sorry for the long post. I was trying to be as detailed as possible.
Sincerely,
Ken

 

[Rick Brandt]

Hi,
I have a form with Tabs on it. On each tab I put a subform.
All the subforms were created from the same table. It was
a big table and I wanted to split it up.
I put a QID on each subform. QID is question ID field.
Each subform looks at a JOB ID from another tabel.
I was hoping that when they were finished filling out the 5 subforms
it would go to ONE record in the table with one common QID.
I am getting it all in one table but as 5 records with 5 different
QID's. They do all go under the correct JOBID though which is
generated by the other table.
Sorry for the long post. I was trying to be as detailed as possible.
Sincerely,
Ken

If they are all looking at the same form, why use subforms? Just use
different *controls* on each page all bound to the same table with the main
form only.

As far as Access is concerned multiple subforms bound to the same table is
identical to multiple *Users* editing that table at the same time.

 

[Guest]

If they are all looking at the same form, why use subforms? Just use
different *controls* on each page all bound to the same table with the main
form only.

As far as Access is concerned multiple subforms bound to the same table is
identical to multiple *Users* editing that table at the same time.

Thanks for the info. I understand what you are saying but I don't understand
how to use different controls on each page.
My form has to be based on 2 tables. One table gives me the JOB ID.
The other table has all the questions on it and when done has the linked JOB
ID field so they all pertain to that job.
Did I give enough info? Let me know.
Ken

 

[Rick Brandt]

Thanks for the info. I understand what you are saying but I don't
understand how to use different controls on each page.
My form has to be based on 2 tables. One table gives me the JOB ID.
The other table has all the questions on it and when done has the
linked JOB ID field so they all pertain to that job.
Did I give enough info? Let me know.
Ken

Well then you might need a main form with ONE subform. I never try to base a
form used for edits on a multi-table query.

My point was that if you have a single form that just happens to have a lot of
bound controls then you can design it exactly the same as you normally would and
place half of the bound controls on one TabPage and half on another TabPage
without introducing a subform at all.

Your original post gave the impression that you thought TabPages had to contain
subforms.

 

[Guest]

Thank you very much for the help.

Well then you might need a main form with ONE subform. I never try to base a
form used for edits on a multi-table query.

My point was that if you have a single form that just happens to have a lot of
bound controls then you can design it exactly the same as you normally would and
place half of the bound controls on one TabPage and half on another TabPage
without introducing a subform at all.

Your original post gave the impression that you thought TabPages had to contain
subforms.