Auto-select first value in listbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list box that displays a list of dates (yyyy) I am populating the
listbox with a query and have it sorted in descending order. When I requery
the list box it displays the new dates as required. However, the new date is
not the selected date.

How do I make sure that when I requery the listbox the first date in the
list is the selected (highlighted) date?

for example:

List box contains

1999 (selected)
1998
1997

I add a new date (2000) and now:

2000
1999 (selected but I want 2000 selected)
1998
1997

Cheers,
Seth
 
Back
Top