Strange behaviour from a combo box on a form when trying to evaluate data in another column (3 Viewers)

GR4YB34RDD

New member
Local time
Today, 05:11
Joined
Feb 15, 2025
Messages
5
I have encountered a strange combo box bug.
I have as the datasource rows of title and the associated ID references.
As you can see from the drop down box the IDs are different in the combo.
But for some reason it does not return the correct ID, when selected, for the third entry.
See video:
I assume this is because the text entries are duplicated and it messes up the workings of the combo box in some way and ignores the ID. The data source for the combo also has the setting to return unique records so i cannot fathom why it is not returning the correct ID after the third selection because it is showing all the records, so evidently it considers them unique. I am aware from a logic point of view that having items with the same name is not wise and i will probably change the title data. Which will in turn probably fix the issue. I just wanted to know why this bug is happening in the first place because the 2nd column clearly shows the IDs are different but for some reason the combo box doesnt return it on the third option.
TESTING UPDATE: Changing the bound column from the text to the ID fixed it.
TESTING UPDATE: Changing the description to a different description also worked when i reversed the bound column change. I guess there is some weird workings going on somewhere that causes the box to bork on a duplicate bound text entry and when it finds the duplicate entry the internal workings just stop and dont update the references to the data in the other column.
TESTING UPDATE; Setting the bound colum to 0 also fixed it.
I guess this is more of a findings and theory post than a question post. Just thought id share as it seemed odd. I guess good practice would be to bind the column to something which has unique data inside it. This obviously may have issues further down the line if used in a similar way to the way i was using it. Which probably was not a very efficient or logical way. We learn from our mistakes though.
Regards,
 
I have just created a combo with duplicate text entries as bound column, yet it returns correct value from second column?
 
I have just created a combo with duplicate text entries as bound column, yet it returns correct value from second column?
That is only accidental. Combos cannot "remember" which of the duplicates you selected which is why combos do not work with duplicate "keys"
 
I have just created a combo with duplicate text entries as bound column, yet it returns correct value from second column
I think that the attached database shows the OP issue. I say it's the normal behaviour.
 

Attachments

Last edited:

Users who are viewing this thread

Back
Top Bottom