how use listbox recordset property with ado memory recordset ?

S

scott w t

i created an ado memory recordset (no disk-based persistent underlying table)
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: Field1="AAA"
record 2: Field1="BBB"

then i set the recordset property for a 1-column listbox whose parent form
is open, as follows

Set lbox.Recordset = r

now --
lbox.ListCount = 2, as it should
but
lbox has 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

use lbox recordset property w/ ado memory recordset? 2
how do i use list box recordset property 0
Wildcard Filtering on ADO Recordset 1
Populating a multi column listbox with ADO Recordset 2
Access 2000 ADO Recordset from Stored Procedure 3
ADP 2003 Form Recordset problem 0
Problem with setting a form's recordset 1
Error 7965 not a valid recordset property 0

Top