How to get index of last entered item in sorted combo box (row source = query)

[MishaLjusha]

Hello. First time on any forum.



With NotInList event I'd like to add "new item" to combo box and select it programmaticaly like [Forms]![frmform2]![cboCombo0].Selected(n) = true. Where n should be the index of last entered item. I have resolved the problem until combo is sorted on unbound column.

As I need the combo to be sorted (unbound column are Last names, so I'd like to have them sorted ascending) and the last entered item gets "to me unknown" index I need some help on this metter.

Or maybe in other words:

Instead of [Forms]![frmform2]![cboCombo0].Selected(3) = true to have it in some way like [Forms]![frmform2]![cboCombo0].Selected("joe") = true.

Any help possible, PLEASE

[ranman256]

IF the cboBox is bound to the name field, then use:
cboBox='Joe'

It's will automatically select. But not for multi selects.

[MishaLjusha]

No. Combo box is bound to ID of "Joe".

[ranman256]

Then you must assign the index,
cboBox=9
then Joe will show.

[Micron]

If you're wanting the index number of the last item entered right after it was entered (which means you can't assign it) you can get the index number of the list item if the last item entered becomes the chosen value. You don't say whether or not it is. So if you had MsgBox Me.cboCombo0.ListIndex you'd see the zero based index number of the selected item. This could be in AfterUpdate or DblClick event

[CJ_London]

cross posted here

https://www.access-programmers.co.uk...26#post1524826

please read this link http://www.excelguru.ca/content.php?184

[MishaLjusha]

Ajax, thanks for the Excelguru.ca link. As I mentioned, this is my first forum ever and I don't know the "rules" of "foruming". So every help is much appreciated. I Will do it correctly next time. Regarding my thread I Will check your solution during the day. Thanks again

[MishaLjusha]

Can I send you (maybe by mail) my sample database (it is very small, 800 kb) to show you exactly what my problem is?
Maybe my line of thinking is absolutely wrog or I can't exactly explain what my problem is.
Thanks in advance

[MishaLjusha]

Ok. I understand that. But how do I get the 9 if I don't know the position of new item in sorted combobox dropdown list

[MishaLjusha]

Ok. Finnaly I got it.
Solved in a manner like Combo0 =DMax("[ID]";"tblNames")