Combo Box Shows the Same Value Multiple Times - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Combo Box Shows the Same Value Multiple Times

Chris Lopez

7 months ago

I Have a Cascasding combo box that works as it should, but when it shows the data i shows the same value 10 times. it shows the complete list from the the correct table, but each value is shown 10 times.
Can anyone tell me what i may have done wrong, and how i can fix this?
Thank you

	Sami Shamma @Reply 7 months ago
Please be more specific. See Rule #2. Show the raw source of the combo box as well as the raw source for the query behind it. Is the Rowsource for this combo box a query? Run the query on its own and see if you have those values duplicated. The odds are you have the wrong link.

	Richard Rost @Reply 7 months ago
Yeah, I've got to concur with Sami on this one. We can't really tell what's wrong without seeing what you got going on there.

	Lars Schindler @Reply 7 months ago
Chris Does your row source have a select statement? If so, it may be sufficient to change ‘Select ...’ to ‘Select Distinct’.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View