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

Form to Table data saving

P: 1
I have a form that I created and added a field called Towing Company. I changed the control source to that field in the table but it is showing the ID number for the company and not the company name. How do I get it to show the company Name instead. I am a new user so please be specific.

Thanks Ohh I am using access 2010
Jul 29 '12 #1
Share this Question
Share on Google+
2 Replies

Seth Schrock
Expert 2.5K+
P: 2,941
What type of control did you add to the form? A combo box or text box? I'm guessing that you have a table for your towing companies. What are the field names in the that table?
Jul 29 '12 #2

Expert Mod 2.5K+
P: 3,284
Yes, you would need to put a combo box on your form, and have as the record source for that combo box a query from the Towing Companies table, using the Company ID and the Company Name.

Easier still, in Form Design view, from the Design Tab of Form Design Tools, in the Tools Group, click on Add Existing Fields, and simply drag the Towing Company Field onto your form. This should add a combo box with the appropriate data behind it (If your table is set up properly).
Jul 30 '12 #3

Post your reply

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