Combo box Help

[Juan4412]

My form has a combo box with the cbobox pulling values from a table for a dropdown list, it set up to return the dropdown option selected to a table. My problem is on the table it is showing the access auto generated id, instead of the salutaion (ie Mr. Mrs. Misses etc.) What need to change to make this take place?

[pbaldy]

Generally speaking, that's exactly what you want to happen. You store the key in related tables, not the text (that's what it's for). If you really want to store the text, change the bound column of the combo, or the rowsource (to eliminate the id field). But then, why bother having an id field?

[Juan4412]

I guess I do not really need to have the id field, I just created a seperate table so that the user could have a drop down menu to choose from, and then bound that combo box to my main table so that the salutation would appear before the first name. Will simply eliminating the key allow the salutation to be returned to the field on my table?

[pbaldy]

As I mentioned, all you really need to do is change the bound column property of the combo or the row source property. If you get rid of the field, you'll have to change the row source anyway.

[Juan4412]

Can you tell me my error? I add two records of sample, and the table show wheer number not salutation selected.

[pbaldy]

I did, twice. The row source is:

SELECT TblSalutations.ID, TblSalutations.Salutations
FROM TblSalutations;

and the bound column is 1, which is the ID. Change the bound column to 2

[jo15765]

As pbaldy has said, right click on your combo box and choose properties. When the properties window displays from there you want to choose the data tab.

On that tab the row source is the 2nd from the top, and place this as the row source --- SELECT TblSalutations.ID, TblSalutations.Salutations
FROM TblSalutations;


Just below the row source is your bound column. You have it set as 1, which is your "ID" and that is why it is returning a numerical value to your table. If you change the bound column to 2 it will then return the salutation that is selected.

To explain further, let's break down your row source....SELECT TblSalutations.ID, TblSalutations.Salutations
FROM TblSalutations;

Your first row source is ID from TblSalutations, so the bound column of 1 would return the data in the ID field. When you change the bound column to 2 it will then return the data in the Salutations field from TblSalutations.

Make sense?

[Juan4412]

Thank both of you for your assistance. I am still very new to access, and did not understand what baldy was meaning, that is why i uploaded a sample. Jo thank you for the detailed in structions as well.