Troubleshoot a list box in form

[Assistancesilvousplait]

Hello,

I am having trouble with a basic list box. I have made a list box in a form
that has 5 options. The rest of my text boxes and check boxes are
corresponding properly with my table, but the data from my list box is not
showing up in my table. I'm not sure where I'm going wrong. I have set the
ControlSource to the correct column, and if I leave the list box unchanged on
the form, with choice #1 listed, it will show up in the table. If I change it
to choice #2, or 3, etc, the field is blank in the table. Would someone mind
pointing me in the right direction to solve the problem.

Thank you so much!

 

[mscertified]

Why are you using a listbox? The only reason to use a listbox is that you can
select more than one item. Use a combo box instead.
Right click and choose 'change to' then 'combo box'.

-Dorian