Updating a Field Name W/ Macro

  • Thread starter Thread starter misschanda
  • Start date Start date
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???
 
"TBD1, TBD2, ..." -- you've just described ... a spreadsheet!

Access is a relational database, and won't work well if you feed it 'sheet
data. In a well-normalized relational database, you'd add a new table to
hold the "many" records of a one-to-many relationship (such as you
describe).

Before you move on to forms and subforms, take another look at the data
structure.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top