Pull results from a query but save results to a table

[michael3426]

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?

[zmbd]

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!