how do i use list box recordset property

S

scott w t

i created an ado memory recordset as follows

Dim r As New ADODB.Recordset
With r
.Fields.Append "Field1", adVarChar, 64
.Open
.Sort = "[Field1] ASC"
End With

then i added 2 records to r and verified that they were actually "there":
record 1 is "AAA" and record 2 is "BBB"

then i set the recordset property for a listbox on an open form as follows

Set lbox.Recordset = r (lbox has 1 column)

now lbox.ListCount returns 2, as it should, but the lbox shows 2 blank
lines, lbox.ItemData(0) and lbox.ItemData(1) both return NULL,
lbox.Column(0,0) and lbox.Column(0,1) both return NULL

is there any way to make this really work? thanks
 

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

how use listbox recordset property with ado memory recordset ? 0
use lbox recordset property w/ ado memory recordset? 2
Who could solve this bug (in my balanced line) 1
How to bind a disconnected ADO recordset to an Access form? 1
how do I pass either a form name or a recordset to the same procedure 2
Get report to print data from ADO recordset created at runtime 4
how do I clone a forms recordset using ADO or how do I get dao.filter to work 7
MS Download Create QBF-how to use listbox 10

Top