Help - Form (tabs or subforms) with data from multiple tables

[bmiller via AccessMonster.com]

I am finding my way with Access 2003 and have spent more time scouring the
web and help menues than I care to admit looking for answers. I am building a
recruitment database and having some issues with getting my form to work as I
want. What I am trying to do is have four related forms (either tabbed forms
or sub forms) which show data/allow input that is all related to individual
candidates (such as a form for contact details, one for job history, one for
skills, one for documents). I have various tables designed and cannot seem to
get them to update as expected.

How can I set up multiple forms that link with the tables behind them? The
tables are all linked by a primary key (Candidate_ID).

I had it working as seperate forms that would update, but when I tried to add
tabs and bring them all together they stopped updating.

Does my ramblings make sense? Can someone help?

thanks in advance to anyone who responds

Bruce

 

[Carl Rapson]

I am finding my way with Access 2003 and have spent more time scouring the
web and help menues than I care to admit looking for answers. I am
building a
recruitment database and having some issues with getting my form to work
as I
want. What I am trying to do is have four related forms (either tabbed
forms
or sub forms) which show data/allow input that is all related to
individual
candidates (such as a form for contact details, one for job history, one
for
skills, one for documents). I have various tables designed and cannot seem
to
get them to update as expected.

How can I set up multiple forms that link with the tables behind them? The
tables are all linked by a primary key (Candidate_ID).

I had it working as seperate forms that would update, but when I tried to
add
tabs and bring them all together they stopped updating.

Does my ramblings make sense? Can someone help?

thanks in advance to anyone who responds

Bruce

You might want to consider having a "master" or parent form, linked to the
most basic candidate table, and subforms that are linked to the other
tables. This is easily accomplished by simply "dragging and dropping" the
other forms onto the parent form, and then establishing the Master and Child
links by specifying the Candidate_ID field. Once you do that, then the
subforms will automatically display the appropriate records for the
candidate displayed in the parent form, and any records entered into the
subforms will automatically receive the proper Candidate_ID value.

The subforms can be directly on the parent form or can be on pages of a tab
control.

Carl Rapson

 

[bmiller via AccessMonster.com]

Thanks Carl for the suggestion.

I am trying to make this work with the forms i have so far, but cannot get it
all to function correctly. i might try to start from a blank form and begin
again

Do you know with sub forms how you can remove the record navigation at the
bottom? I only want one record navigation at the bottom of the main form, not
addtional ones with sub forms - so when I click next record it takes every
form/subform to the next record (ie based on primary ID key)

again - thanks in advance

Bruce

I am finding my way with Access 2003 and have spent more time scouring the
web and help menues than I care to admit looking for answers. I am

[quoted text clipped - 23 lines]

Bruce

You might want to consider having a "master" or parent form, linked to the
most basic candidate table, and subforms that are linked to the other
tables. This is easily accomplished by simply "dragging and dropping" the
other forms onto the parent form, and then establishing the Master and Child
links by specifying the Candidate_ID field. Once you do that, then the
subforms will automatically display the appropriate records for the
candidate displayed in the parent form, and any records entered into the
subforms will automatically receive the proper Candidate_ID value.

The subforms can be directly on the parent form or can be on pages of a tab
control.

Carl Rapson

 

[Carl Rapson]

Open each subform in Design view and set the Navigation Buttons property to
No.

Carl Rapson

Thanks Carl for the suggestion.

I am trying to make this work with the forms i have so far, but cannot get
it
all to function correctly. i might try to start from a blank form and
begin
again

Do you know with sub forms how you can remove the record navigation at the
bottom? I only want one record navigation at the bottom of the main form,
not
addtional ones with sub forms - so when I click next record it takes every
form/subform to the next record (ie based on primary ID key)

again - thanks in advance

Bruce

I am finding my way with Access 2003 and have spent more time scouring
the
web and help menues than I care to admit looking for answers. I am

[quoted text clipped - 23 lines]

Bruce

You might want to consider having a "master" or parent form, linked to the
most basic candidate table, and subforms that are linked to the other
tables. This is easily accomplished by simply "dragging and dropping" the
other forms onto the parent form, and then establishing the Master and
Child
links by specifying the Candidate_ID field. Once you do that, then the
subforms will automatically display the appropriate records for the
candidate displayed in the parent form, and any records entered into the
subforms will automatically receive the proper Candidate_ID value.

The subforms can be directly on the parent form or can be on pages of a
tab
control.

Carl Rapson

 

[bmiller via AccessMonster.com]

Carl

you are a ripper - this works a treat and is how I envisaged it.

Bruce

Open each subform in Design view and set the Navigation Buttons property to
No.

Carl Rapson

Thanks Carl for the suggestion.

[quoted text clipped - 36 lines]

 

[Guest]

Hello, I was reading your help reply in the Access group discussion back in
June and you were very helpful. I did what you stated with the Subforms but,
still having a little problem with mine. I have in each form a Plan Name
that is sold 2 different ways. When I go to the end of the subform and back
to the next record on the main form, the 2 subforms stay at the last field.
How can I fix this to where it would automatically go to the first field on
the subform.

Any help is appreciated