Adding information to a list box..is this possible? (1 Viewer)

[RobinL]

/EDIT I wored a different way round the problem using a query, still i'd quite like to know the answer

I have 3 recordsets open, for orders, institutions and contacts

I want to add information from each of these recordsets into individual records in a listbox e.g.

Lstbox lstOrderInformation

Name...|...Institution......|....Orderdate
--------|---------------- |--------------
Rob.......|..CollegeA.........|...5/6/02
John.....|...CollegeB.........|...4/12/02
James...|..CollegeC.........|...1/1/03
-----------------------------------------------


Is it possible to display my values this way and if so how?

Thanks,

Robin

 

[WayneRyan]

Robin,

You can use a union query to populate your listbox.

Select flda, fldb, fldc from Table1 UNION
select flda, fldb, fldc from Table2 UNION
select flda, fldb, fldc from Table3;

hth,
Wayne