AddList

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have strSQL expression that rerturns 3 columns: CustomerID, CustLname, CustFname
With rsCustID, I want to populate the 3 columns in a listbox. I look at ACCESS help and it says expression.AddList(Item,Index). So far I hav

rsOne.Open..

With rsOn
.Fields(0

Can anyone tell me how I can take my recordset, and populate the 3 columns in the unbound listbox? Basically the user clicks a button to search for a customerID, and a strSQL expression executes to return the matches. I need to take the 3 columns of my matches (resultset) and populate the listbox, but I don't know how to do it using AddList method. Thank
 
you might try a combo box_change event

----- Toco Hara wrote: ----

I have strSQL expression that rerturns 3 columns: CustomerID, CustLname, CustFname
With rsCustID, I want to populate the 3 columns in a listbox. I look at ACCESS help and it says expression.AddList(Item,Index). So far I hav

rsOne.Open..

With rsOn
.Fields(0

Can anyone tell me how I can take my recordset, and populate the 3 columns in the unbound listbox? Basically the user clicks a button to search for a customerID, and a strSQL expression executes to return the matches. I need to take the 3 columns of my matches (resultset) and populate the listbox, but I don't know how to do it using AddList method. Thank
 
Back
Top