J
Jeff C
Hopefully this will be clear.
I have a main table joined one-to-many with another (tbl2) and a main form
based on that table. On the main form I am using subforms on a tab control ,
six subforms on six tabs all control sourced to (tbl2). Subform 1 for
questions 1-30, subform 2 for questions 31-60, etc, etc.
This works fine for the data entry.
I am trying to build a similar form to view the data entry but with the data
entry on many records to the one, when viewing subform 3 the user may have to
use the record navigation bar to progress to the record with the data for
subform 3.
I would like to set it up so that tab 1 with subform 1 shows the record with
the fields for subform 1, Tab 2, subform 2, data for fields on subform 2. Is
this possible??
Thank You
I have a main table joined one-to-many with another (tbl2) and a main form
based on that table. On the main form I am using subforms on a tab control ,
six subforms on six tabs all control sourced to (tbl2). Subform 1 for
questions 1-30, subform 2 for questions 31-60, etc, etc.
This works fine for the data entry.
I am trying to build a similar form to view the data entry but with the data
entry on many records to the one, when viewing subform 3 the user may have to
use the record navigation bar to progress to the record with the data for
subform 3.
I would like to set it up so that tab 1 with subform 1 shows the record with
the fields for subform 1, Tab 2, subform 2, data for fields on subform 2. Is
this possible??
Thank You