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

MS Access: Pulling Data From One Table To Another Table

P: 1
I desire to pull certain fields from a record in one table into a different table using a drop-down box in form view. How is that accomplished? I trully need step by step instructions. I have read programing books on how to do it, but it never works. I have never met anyone who knows how to do it. You can be the first.

Thank you! My God bless you for your efforts!!!!
Feb 6 '08 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
I desire to pull certain fields from a record in one table into a different table using a drop-down box in form view. How is that accomplished? I trully need step by step instructions. I have read programing books on how to do it, but it never works. I have never met anyone who knows how to do it. You can be the first.

Thank you! My God bless you for your efforts!!!!
I'm not sure exactly what you are looking for. However if you have a dropdown box (cboCust) with 5 field from tblCustomer as follows:

SELECT custID, custName, custADR1, custADR2, custADR3
FROM tblCustomer;

Then you can refer to those fields as follows:

Me.cboCust - will refer to the custID field assuming its the bound field
Me.cboCust.Column(2) - will refer to the custName field

and so on.

However, inserting duplicate information from one table to another is not encourages in databases as it causes problems. I suggest you check out this tutorial first.

Database Normalization and Table structures
Feb 6 '08 #2

Post your reply

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