1) Pop the a SQL statement referring the query into the row source (the wizard guides you through this)
2) Populate an ADO recordset. Set the cursor location to the client. Set the recordset as the listbox recordset.
3) As 2 but instead of assiging the recordset, use the ToString method to get a deliminated list of values, set the listbox to value list and pop the string in the row source.
The first option worked, however I have a search form where a user might type in part of an address, then the query would filter only the records that match. The way it is now, the list box is showing all records (not the filtered query results).