I have a databse in access 2000. i'm running a query called mailinglist. It filters records and list clients according to my specs, that works fine.
Now on a form named mllist i have a command button called cmdmail & a list box called lstmail.

What i want to happen, is upon clicking cmdmail, it fills lstmail with the contents of the query. Below is the sql for the query.

I am totally lost and would appreciate any help.


------------------------------------------------------------------------------------
SELECT [Roll].[ContactID], [Roll].[LastName], [Roll].[FirstName], [Roll].[title], [Roll].[address], [Roll].[postal address]
FROM Roll LEFT JOIN [Find duplicates for Roll] ON [Roll].[address]=[Find duplicates for Roll].[address]
WHERE ((([Find duplicates for Roll].[address]) Is Null));
------------------------------------------------------------------------------------

How do i call the query from the button (I can do that) i just want to know about outputing it to the textbox.

All help appreciated.