By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,398 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

Subform and Mainform

P: 17
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
Feb 20 '09 #1
Share this Question
Share on Google+
3 Replies


RuralGuy
Expert 100+
P: 375
You are really struggling *against* normalization rules. You may wish to read up on Normalization. Google will help there.
Feb 21 '09 #2

100+
P: 675

NeoPa
Expert Mod 15k+
P: 31,418
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.
Feb 21 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.