Automatically link 20 Sub Forms to one main form

[Jen_RT]

I have 20 subforms all with their own primary key eg (01-000001, 02-0000001, 03-000001) and so on, where the 01 relates to the subform number and within that subform the 000001 part increments by one each time.

The main form is MTF-000001, again with the 000001 part incrementing by one.

Is there a way to assign the subforms in the back ground of the database user so that for every main form created eg MTF-0000001, subforms 01-000001, 02-0000001, 03-000001 and so on are automatically created and linked to the main form?

Any help would be greatly appreciated!

 

[DCrake]

I think you are not clearly using access in the way it is supposed to be used. Why are you attempting to create parent and child forms for individual parents?

You should only have one main form and one sub form. You can have a sub form in a sub form (nesting) but clealry you would not create a form for every record.

What type of data are you using in your database that makes you think you need to create numerous forms?

David

 

[Jen_RT]

In each of the sub forms are a series of questions and the response given dictates the progression onto other forms. For example. at form 9, the user may exit the data entry process, and at other forms, the user may skip certain sub forms.

Does this make any more sense?

I was initally linking the forms myself, but the client wants them linked in the background so they are less prone to user error.

Thank you.

 

[gemma-the-husky]

it doesnt really make sense - note that although your client may know what he wants to achieve, he wont understand the best way to achieve it - and he will need guidance in this area

if you find you have more than 1 subform, there is probably something amiss

---------
bascially you either have a form (a subform is just a form) that shows one item at a time, with a navigation button that steps through the items

OR

a continuous form that shows selected details for each item, on a single row, but displays multiple rows (all the rows) at the same time - with a scroll bar to change the items being viewed.


but in both cases, the items themseleves are all of the same type

------
can you expand on what you are trying to do