Auto-select first value in listbox

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Marking items as selected in a Muli-Select listbox 3
multi select list box if nothing selected 12
compare fields in listbox 3
how do i get listbox selected data into table 3
Access Cannot select items in listbox 1
Listbox requery 1
Move record selected in Listbox to top of listbox control 8
Multi Select Listbox or subform! 14

Top