M
misschanda
BackGround:
I have two tables; tbl1 and tbl2. From the tbl1 i have created 7 subform and
from tbl2 i have created one form that includes all the subforms.
The subforms 1 and 5 are a comparison of each other i.e. Target Measurements
and Acutal Measurements. All repeatable measurements are listed as
fieldnames; however measurements that we currently don't do, but plan to do
are listed by the field names TBD1, TBD2... TBD9.
My Boss would like to keep them as TBD1-TBD9 consequently updating the
subforms 1 and 5 automatically when the TBD(s) field names are known or
needed for the particular trial
Question:
Is there a Macro design that I can put in the form to automatically update
the table and consequently the form and report???
I have two tables; tbl1 and tbl2. From the tbl1 i have created 7 subform and
from tbl2 i have created one form that includes all the subforms.
The subforms 1 and 5 are a comparison of each other i.e. Target Measurements
and Acutal Measurements. All repeatable measurements are listed as
fieldnames; however measurements that we currently don't do, but plan to do
are listed by the field names TBD1, TBD2... TBD9.
My Boss would like to keep them as TBD1-TBD9 consequently updating the
subforms 1 and 5 automatically when the TBD(s) field names are known or
needed for the particular trial
Question:
Is there a Macro design that I can put in the form to automatically update
the table and consequently the form and report???