424,289 Members | 1,875 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,289 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.
Nov 29 '18 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 2,888

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!
Nov 29 '18 #2

Post your reply

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