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

Pull results from a query but save results to a table

P: 1
I managed to figure out how to pull 3 fields from a query into a combo box. However, I want to save those results into a separate table. For instance, I have a query that pulls together the LastName, FirstName, and Phone number fields into one drop down box. But now I want to take that result and save it to another table because when I close the form that inforamtion doesn't save when I open the form again. Any ideas?
Dec 3 '13 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,287
michael3426:
You don't normally do that... > Database Normalization and Table Structures.

You store the data in the tables, and when you need to construct the string you do so in a query, form, report at the time of need - exactly as you appeared to have done in the cbo-control d(^_^)b ! You would due basically the same thing in a query calculated field or a report control.

It would be helpful for you to work your way thru the following website tutorials to get a feel for how a normalized database should be setup and utilized:
MS Access 2010 Tutorials
Access Basics - By Crystal

Mind you these are just the basics and will not take you much time at all to work thru; however, the tools you gain by doing so will save you a ton of headache later!

You will also find a ton of usefull information in the insights articles[*] Microsoft Access / VBA Insights Sitemap that will save you alot of time and frustration!
Dec 3 '13 #2

Post your reply

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