423,850 Members | 1,555 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,850 IT Pros & Developers. It's quick & easy.

select multiple records and save it to master table

P: 1
Hi, i have a form and a subform. On form i have a combo box. basis selection of combo box need to show related table in subform with option to select multiple records. when records are selected need to insert selected records to master table. Please advise how to get this done.
2 Weeks Ago #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 2,704

Welcome to Bytes!

First, I must ask the reason for copying these records from one table to another. If you have the records, there should be no need to copy them from one table to another. You should be able to designate how your Table is filtered to show any records you desire.

This somewhat guides us to your questoin at hand. How are you selecting the records in your subform? If there is a check box, or some indicator within that table to indicate that a record should be copied to another table, then that becomes your filter.

Trust, me, I've been through this type of DB model you are describing, and it does nothing but cause headaches. There may be a good reason for this transfer of records, but it is not quite apparent on the surface of your question.

However, to do what you want to do, you ned to simply create an INSERT Query, based upon the selection criteria you use for selecting the records. Without any more information, we are helpless to provide any more specific guidance.

Hope this hepps!
2 Weeks Ago #2

Post your reply

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