I have a listbox on a main form that populates from the entry the user makes on the same form. When the new entry is populated in the listbox it is not highlighted. After the newly entered record populates the listbox it is not highlighted, like when the user clicks on it. There is a caveat to this. When the record populates and shows in the listbox, it may not always be the first or last record in the list. The listbox is sorted by date. So the new entry is in the list by date. Also, the entry the user completed is still displayed on the form and the ID shows in the listbox and in the textbox of the entry. Below is what I have so far. If I breakpt and step thru, the IF line will match as the loop goes thru. But, when the column equals the txtNoteID, it does not drop into the THEN but continues to loop until the end.
If anyone has any thoughts, ideas, suggestions, recommendations (other than retire) I am listening.
Dim i As Integer
For i = 0 To Me.lstMeetingNote.ListCount - 1
If Me.lstMeetingNote.Column(0, i) = Me.txtNoteID Then
Me.lstMeetingNote.Selected(i) = True
Me.lstMeetingNote = Me.lstMeetingNote.ItemData(i)