Multiple Tab Form

[JD McLeod]

I have a form that is used for data entry into the main table of my project.
This table stores all of the organizations internal controls. Each quarter
when the controls are audited, the auditor uses a form to enter his findings.
Currently, there is one form with 4 identical sections on it, one for each
quarter. Some of the auditors have complained that the single form is too
long and it is easy to loose your place. I thought a good solution would be
to create a tab for each quarter. The auditor would still launch one form,
but would have a tab for each quarter. When he finished updating the first
control, he could use the record selector and advance to the next control
with 4 new tabs.
First question>> The way I did this first was to create a blank form, then
add a tab control with 4 pages and then a subform on each tab, telling the
subform to use an existing form. Is this the best way to do this? It seemed
to work.
Second question>> The problem I had was that on my old form, when the user
finished filling in the form, they could use the record selector at the
bottom of the form and advance to the next control. With the way I have
designed it using the tabs, it doesn't want to let me do that. How can I
get it to roll all 4 tabs forward to the next record?
Sorry for being so lengthy, but I didn't know any other way to explain it.

 

[tina]

if all of the fields are in one table, don't use subforms - just bind the
table to the form, add the tab control, and put the specific controls you
want on each tab. the navigation buttons at the bottom will move from record
to record in the form's underlying table.

having said that, from your description "Each quarter
when the controls are audited, the auditor uses a form to enter his
findings.
Currently, there is one form with 4 identical sections on it, one for each
quarter.", it sounds like your table is not normalized. if it is, great - i
just got the wrong impression. if it isn't, or if you don't know what i mean
by normalized, recommend you STOP before going any further, read up on data
normalization rules, and seriously consider normalizing your
tables/relationships design before going any further in developing your
database. for more information on normalization, see
http://home.att.net/~california.db/tips.html#aTip1.

hth

I have a form that is used for data entry into the main table of my project.
This table stores all of the organizations internal controls. Each quarter
when the controls are audited, the auditor uses a form to enter his findings.
Currently, there is one form with 4 identical sections on it, one for each
quarter. Some of the auditors have complained that the single form is too
long and it is easy to loose your place. I thought a good solution would be
to create a tab for each quarter. The auditor would still launch one form,
but would have a tab for each quarter. When he finished updating the first
control, he could use the record selector and advance to the next control
with 4 new tabs.
First question>> The way I did this first was to create a blank form, then
add a tab control with 4 pages and then a subform on each tab, telling the
subform to use an existing form. Is this the best way to do this? It seemed
to work.
Second question>> The problem I had was that on my old form, when the user
finished filling in the form, they could use the record selector at the
bottom of the form and advance to the next control. With the way I have
designed it using the tabs, it doesn't want to let me do that. How can I
get it to roll all 4 tabs forward to the next record?
Sorry for being so lengthy, but I didn't know any other way to explain

it.