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