MS Access Combo Box/Append Query

[fallenangel820]

I have a form that has a couple text boxes and some combo boxes and one button. I am using an append query and a button to update a table based on the values in my text boxes and combo boxes. The issue I am running into is that the combo boxes are displaying the numerical position of the item in the list instead of the actual item I select. For example:
I have a combo box with these choices


Yes
No
Maybe

If I hit the drop down and select No then I end up with number 2 in my table instead of the word no. How can I have it append the actual value from my combo box?

[pbaldy]

Typically you would use the numerical key value in other tables. If you don't want to, might as well get rid of it. You can also change the bound column of the combo, but I wouldn't.