Sorry guys, I'm completely new to databases so maybe this is a very stupid question, but we'll see that later.

I have a database with a lot of customer data and I want to do this search on it:
VB Code:
  1. Set RS = DB.OpenRecordset("SELECT * FROM Customer WHERE UserName = 'Smith'", dbOpenDynaset)
This gives me multiple records since there are more then 1 Smiths in my db. How do I get all these records. 'cause if I now do this:

VB Code:
  1. With RS 

  2. blablabal

I only get the first record.

What do I need to do to get all the records and put there names say in a listbox?

tnx very much !