Choose varying number of subforms

[hilian]

I am designing a data-entry system in Access 2003 for a clinical case-reading study. The questions that the case readers have to answer are divided into modules, and different batches of records use different modules, but all batches use a core module which includes identifying information and a set of questions that apply to all cases. The modules can include anywhere from about 15 to 60 questions. Some of the modules have been written, but the idea is to create new modules as the need arises. The data will be exported to an Excel spreadsheet for analysis. There is no need to plan for reports and this isn't really a relational database.

The problem is to allow the reader to enter data for the relevant modules, sometimes one, sometimes four or five or more.

I have created a main table for the core module and a form to go with it. I’m assuming I need to create a separate table, related to the main table, for each module and an accompanying subform for each table.

How do I create a menu system that will allow the case reader to choose only the subforms needed for a particular record?

Many thanks for any help.

Henry

 

[hilian]

Thanks Uncle Gizmo for your three suggestions. I was actually using tabs for sections of the core module. It never occurred to me to use tabs for the subforms for the other modules. That would make it much easier for the case readers.

I think that solves my problem. I'm about a day away from trying it. I'm expecting it to work without a problem, but if there are any, I'll ask again.

The videos on questionnaires were interesting, and I learned some things, but I don't think they were directly relevant to the current problem.

Many Thanks,

Henry