Dynamic form, columns of subform based on a table that changes with each application

[sparker]

Hello!

I want to make a form/subform that can be used across clinical
trials. The form container for the subform won't change. However,
the columns of the sub-form will change based on records in a table.

I have a table of subjects with unique identifiers. I have a table of
vital signs. The vitals collected for each study will be different.
The vitals are collected at multiple time points. I want the subform
to show the unique identifiers for the subjects as the rows and the
columns to be the vital signs.

Once collected on the form, I'd like to transpose the vitals into one
vital sign per row per subject per timepoint. I know you're asking
why would I collect them one way and store them another way. Its for
ease of the data entry. The data is collected on a form that has one
line per subject. There is no desire to change the form.

Thanks in advance.

Sue

 

[sparker]

I should also note that I'm using Access 2003, but the database is
Access 2000 (don't ask). I'm not using ADO, only DAO.