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

how to transfer a set of records from a table from another table

P: 1
Im having a problem in transfering a set of records from a table to another table. The scenario is when i select combo box (Course taken such as diploma in IT), then the process will automatically save the list of subjects that need to be taken by students into student course info table.. i hv link all the related table together... I had tried a few solution but still cant... Hope somebody can help.... Thanks a lot! :)
Jan 22 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,072
Would be easiest by creating an append query and execute that from code to add the StudentID like:

currentdb.execute ("insert into tblX (select " & me.studentid & " as studentid, field1, field2 from tblY )")

Jan 22 '07 #2

Post your reply

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