Linking forms

[TFisher]

I am new to MS Access, so I'm wondering if someone can help me with this. I'm setting up a data entry system whereby I'm trying to link forms together. I have a data sheet comprised of 5 different sections, and I've created an MSAccess form for each section. I want the user to go into the first form, enter the data for a single subject, then proceed to the next form and enter the data for that same subject, and so on.
I've seen how a macro can help me link the forms together (although they seem to appear in reverse order), but how can I set up a form so that it only accepts data for a single subject?

 

[Charlie]

Dear T,

I hope I've understood what it is that you need:

You want a set of forms that link together so that one entry in your table is made up from the entries in the 5 forms??

Is it vital that you have 5 seperate forms? I would be tempted to use just one big form using a tab control thingy that will allow you to enter different info on each page. This would all be linked to the one record in your table and might be a lot less stress.

If you really need to have five forms then it should be possible to have them all with the same record source but just showing different controls. The form should allow you to enter data into a record that is already partially filled in by other forms.

I'd still go for the tab control thingy though.

Hope this helps,

Charlie

 

[TFisher]

Charlie,

This is a clinical case report form that I am working with. These forms, depending on who designs them, can be rather disorganized. In this situation, certain sections have only one record per subject, while other sections will have multiple records per subject. It's generally best to keep each section in its own table. As long as there is a common subject ID number among them, it will be easy to link records from different tables later on.
I have been able to link multiple forms together by using a macro, which contains a series of OpenForm commands (one for each form). However, I have found it odd that I have to specify the form names in the reverse order of how I want them to come up on the screen.
At this point, still, I have not discovered an easy way to carry the value of Subject # from one form to the next so the data entry person does not have to enter it each time. I'm not sure whether to use a macro or VBA. A book I have seems to indicate that VBA would be more appropriate.