Selecting from a DataList control within coding?

[Frosty]

With the standard Listbox or the Combox controls, it is possible to manually select an item from within list using the ListIndex function.

List1.ListIndex = 1 (or whatever other number).

However, the DataList and the DBList controls seem to lack this function. Is there another way to do it? TIA.

[Borry]

Hi Frosty,


did you find any solution for this ?

I'm looking for exactly the same thing.

Thanks in advance,


Bjorn

[oh1mie]

You can use DataList1.BoundText for that

If you bounding Id (like id=123)
DataList1.BoundText=123

Db.Execute "delete * from mytable where id=" & Val(DataList1.BoundText)

[Borry]

but I don't want to delete it or so .... I just want that the first item in the data list is selected.

Thanks in advance !

[oh1mie]

Originally posted by Borry
but I don't want to delete it or so .... I just want that the first item in the data list is selected.

Thanks in advance !

"select * from mytable where id=" & Val(DataList1.BoundText)

[oh1mie]

Private Sub Form_Activate()
    Screen.MousePointer = vbDefault
    If Not Data2.Recordset.EOF Then
       DataList1.BoundText = Data2.Recordset!Id
       DataList1_Click
    End If
End Sub