Subform and Mainform

[gblack301]

Hi All,
I have been racking my brain for sometime in trying to resolve this and now I am just wiped out.

MS-Access 2003

I have a main form that contains several selection options (combo boxes). This main form is opened with an argument from another form and this main form is bound to a table.

The main form has a subform that is bound to query that contains a set of records based off the opening argument from the main form.

When the save button is hit I want to write a record to the bound table of the main form for each of the records in the subform and combining the selections from the main form.

Here an example:

SUBFORM

recordA
recordB
recordC


MAINFORM

selection1
selection2
selection3
selection4

When the save button is hit I would like these records added to the table.

Autonumber, recordA, selection1, selection2, selection3, selection4
Autonumber, recordB, selection1, selection2, ,
Autonumber, recordC, seletion1, selection2, ,

I hope that I am making sense here in what I would like to accomplish. Any input would be greatly appreciated.

Kindest Regards,
Gblack301

[RuralGuy]

You are really struggling *against* normalization rules. You may wish to read up on Normalization. Google will help there.

[OldBirdman]

Or try http://bytes.com/topic/access/insigh...ble-structures in this forum.

[NeoPa]

It will mean redesigning the structure of your tables, and the relationships between them, but should give you more flexibility and ease of manipulation in the long run.