Select an particular item when a listbox opens?

alastair · December 27th, 2005, 01:31 PM

1) I have a listbox of names which is populated by one of several queries, selected by VBA according to the user's selection on a form. I want to fix it so that when the listbox opens the item highlighted is the first name alphabetically. I wrote code which identifies the correct name, the problem is that I can't find how to make the list box select it.

2)I was surprised to find that the requery method seems to have no effect while the action works just fine - any clues to why that is?

Me.lstPicklist.Requery 'This method doesn't have any effect
DoCmd.Requery "lstPicklist" 'This works fine

Thanks

Bob Bedell · December 27th, 2005, 06:50 PM

Hi Alastair,

lstListBox.Selected(0) = True

lstListBox.Selected(1) = True, would highlight the second item in the list, and so on.

HTH,

Bob

alastair · December 29th, 2005, 06:04 PM

Thanks, that's got it. As for the other problem, I think there's something weird with the form so I'm going to start over.