Very Computer

I have to read a 6 fields into 6 listboxes for searches. No updating of
the database is needed. I am reading a dbase IV file. I've tried sql
queries:
sql="SELECT [field1],[field2],[field3]...FROM database Where
[field1]='something'

set rs.openrecordset(sql,...)

or data control to list boxes, but I always end up doing the ol':
while not rs.eof
        if not isnull(rs![field])
                lstSomething.additem rs![field]
        end if
        rs.movenext
wend 'if I live that long

When I set up a data control and use DBList box, it autofills quickly,
but does not support looping thru the list. Is there a way to get a
listbox to autofill? I can live with searching in memory-got lots of
that!