Selecting from a DataList control within coding?

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.

Hi Frosty,


did you find any solution for this ?

I'm looking for exactly the same thing.

Thanks in advance,


Bjorn

You can use DataList1.BoundText for that

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

Code:

---

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

---

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 !

Quote:

---

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 !

---

Code:

---

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

---

Code:

---

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

---