AUTOselect in LISTBOX

[Compuboy]

When the form is opened I want the first item in the list box to be selected and highlighted...you can do this with a combo box but what would I need to type (Under Private Sub Form_Open) to do this with a list box??

THANKS

 

[RoyVidar]

Perhaps in the on load event of the form, try:

[tt]me("lstMyList").selected(0) = True[/tt]

(should you display column heads, try 1 in stead of 0)

Roy-Vidar

 

[Compuboy]

it works except..after I open the form and the first thing is selected...it will not let me select anything else.

 

[RoyVidar]

That's probably to do with some properties of the listbox (enabled/locked (or forms allow edits false?), not updateable controlsource...)

Roy-Vidar

 

[Compuboy]

When I put this code in Form_Open:

Me("ListBox").Selected(0) = True

It does select the first item..however, after I cannot switch the selected item...everything just gets locked.

 

[jdegeorge]

Roy

Is there something similar for Combo boxes?

Jim DeGeorge

 

[RoyVidar]

I think there are two alternatvies in my second reply here thread702-995936. A third alternative could be

[tt]me!cboMyCombo.value = me!cboMyCombo.column(0,0)[/tt]

- should the bound column be the first column.

Roy-Vidar