Solved Combo Box only enters first item on list

[Dark Stranger]

I have a combo box with a list that changes depending on the selection in another combo Box. The list in the second box is changing correctly when I change the selection in the first box, however when i select an item in the second list it only enters the first item on the list into the box??????? I'm a noob with Access. What info would you need to answer?
Thanks
DS

 

[theDBguy]

Can you show us some sample data of what is in the second combobox? Also, can you post the SQL statement for your combo?

 

[strive4peace]

howdy stranger,

it sounds to me like the bound column of the combo box isn't unique. Is it hidden?

(nice to see you here too, L)

 

[Dark Stranger]

I have no Idea what I did wrong. I renamed boxes and fields to make sure they were all unique, then I deleted and re-entered the query code. Now it is working. Thanks for the help

 

[strive4peace]

great! glad you got it working. Happy to help

 

[theDBguy]

I have no Idea what I did wrong. I renamed boxes and fields to make sure they were all unique, then I deleted and re-entered the query code. Now it is working. Thanks for the help

Hi. Glad to hear you got it sorted out. Good luck with your project.

 

[Dark Stranger]

Thanks guys. Your help was greatly appreciated.