AddList

T

Toco Hara

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
 
G

gramps

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to display values in 2nd list box from 1st list box selection 2
Requery not working 8
Want to avoid the possibilty to edit field in listbox 6
Count Values in a Range, Not Formulas 2
runtime error when trying to update table based on form input 1
Use VBA to Populate Listbox from Open Spreadsheet 4
Multi Select ListBox 11
dealing with Null and zero-lenght string and...listbox 0

Top