Forum Discussion
Setting value to a second column of a ComboBox not Showing
All you need is to bind the first column:
Bound Column: 0
Then set the Value and requery the form:
Me!cboPurDate.Value = 20261019 Me.Requery
There are two things about this that have a bearing on the problem.
First 20261019 doesn't look like a date value to me. It looks like a string of digits which happen to correspond to the digits in YYYYMMDD. That is to say, it's looks like a string formatted representation of a date. Since you don't show us how it gets formatted, we can't really do more than guess at that.
The second thing is that you are trying to set the second column in the combo box to that value in VBA. I don't know what that would accomplish, but I doubt that's really what you are aiming to accomplish.
Columns in a combo box are Indexed, from left to right, starting at 0. That means the first column is actually column(0). Typically the bound column is that first column, Column(0). Trying to set some value for the second column isn't a valid thing to do.
So, my guess is that you are trying select that date value, which itself already seems problematic because of the formatting.
One or both things could be involved here. Please provide details about the issues raised so we can try to help figure out where it is going wrong.