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.
-
-
shehzi,
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!
Comment