MS Forms 2.0 ListBox Adding Multicolumn items

[Guest]

I am having a problem doing the following -
I have a normal Access 2000 listbox control populated from a crosstab query
- the idea being that users can compare 2 sets of data side by side.
What I want to do is automatically move any items that don't match to
another list box. I'm using an MS Form 2.0 listbox control as it has the
AddItem method, by the way.
I have tried a number of ways but they all seem to just add a row and not
populate the columns.I've tried the following code-
'creating an array
aArray(0, lRow) = (lstCrossTab.Column(0, varItem))
aArray(1, lRow) = (lstCrossTab.Column(0, varItem))
'Adding the items
lstAppend.AddItem aArray(0, lRow)
lstAppend.AddItem aArray(0, lRow)

The number oif items could run in the thousands so I can't just use a normal
listbox control and set the rowsource to Value list and populate it that way.

I've searched just about everywhere and I am now at a loss...

Any help would be appreciated.
Thanks in advance
Dominic

 

[John Nurick]

Hi Dom,

Why not just use two continuous subforms, one bound to a query that
returns the matching items and the other to a query that returns the
others?