Query

[brianh]

If I would like to query a DB and place a certain field into a list box. How would I do this? Example:

fieldname = name

place all name field entries into a list box that fit the following criteria:

certain ID
certain date(s)
etc

All of the above are field names in the DB.

[jp_schwartz]

Fill your recordset, then:

list1.clear
do while not rec.eof
list1.additem rec.fields("your field").value
rec.movenext
loop
rec.close