none
Populate ListBox in Boundless Form Using an ADODB Recordset RRS feed

  • Question

  • I have a boundless form with a listbox that displays the results of a SELECT query. 

    Is it possible to poplulate the listbox with the contents of a Recordset?

    Something like:

    strSQL = "SELECT FirstName, MiddleName, LastName, Address FROM ClientTable WHERE LastName = 'Smith'

    cn.Open "ConnectionString"

    rs.Open strSQL, cn

    MyListBox.RowSource = rs

    Thanx,

    tod

    Monday, August 22, 2016 8:12 PM

Answers

All replies