Access List Box help

[jpack23]

I have a list box whos source is a query, the list actually turns out to be kinda long and in alphabetical order. Problem is, when I select an item in a list and then click a command button to process the Item just selected in the list box is still highlighted...I want the list box to return to the very beginning.

For example.....When I first open the form the list box shows all items from the query in alphabetical order, I then scroll down and choose something that starts with an "S", then I click a button and then return to the list box, but the list box still has the "S" item selectd and highlighted instead of returning to the beginning "A" items.Anyone help?

Thanks

 

[fneily]

Add at the end of your command button code
Me![ListboxName].Requery .

 

[TheAceMan1]

How are ya jpack23 . . .

or . . . works in all versions:

[blue]   Me![purple][b]ListboxName[/b][/purple].RowSource = Me![purple][b]ListboxName[/b][/purple].RowSource[/blue]

See Ya! . . . . . .