Solved Combo Box only enters first item on list (1 Viewer)

Dark Stranger

New member
Local time
Today, 05:58
Joined
Mar 28, 2020
Messages
10
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

I’m here to help
Staff member
Local time
Today, 04:58
Joined
Oct 29, 2018
Messages
21,357
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

AWF VIP
Local time
Today, 06:58
Joined
Apr 3, 2020
Messages
1,003
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

New member
Local time
Today, 05:58
Joined
Mar 28, 2020
Messages
10
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
 

theDBguy

I’m here to help
Staff member
Local time
Today, 04:58
Joined
Oct 29, 2018
Messages
21,357
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.
 

Users who are viewing this thread

Top Bottom