Sound like an odd thing to do, but in this case it would be easier on the end users of the database I am working on.

The short of it - I have a form that shows a listing of Keywords associated with a Keyword Group. You can select the Group and the listing will show all the keywords under that group. You can also do a lookup (in the combobox in question) to see if a Keyword you want exists. When this is done (the source for the combobox as 2 fields, Keywords, and keygroup) the form will switch to the approprate keygroup, with the combo box being bound to the 2nd column (keygroup). All seems to work well, except when you select an item from the lookup that is not the first in that group. The lookup still works, but the value in the combobox changes to the first item in the group. So if group A had 1,2,3,4 as the first four keywords, and I selected 3, the form would shift to the Group A, but the combo box would change to 1. This may confuse the end users as the item they selected is not shown in the box they selected it from. It works, but it may confuse them.

I think I know how to do it, but it may be that I am using the wrong event? Here is my code. I actually see the selection flicker, but it still goes back to the first in the group.

Please Login or Register  to view this content.
I have tested the ListIndex at that begining and end of this code, and it does change to the first of it's group, though I don't actually know why.