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
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