I am trying to put an SQL query result into a recordset. It only puts one entry into the recordset and I know there are multiple results from the query. How do i get all of the results fo the query to go into the recordset and can't I put the recordset into a list box or some other way of displaying it on a form?