Displaying Query Results in List Box

[Ana Nelson]

I would like to display multiple rows of a query in list box. If I use 
the Database Query Builder and set the Database property of a list 
field to the relevant Query, then the results display somewhat like a 
spreadsheet which is what I want.

I would like to know how to accomplish this manually.

If I say:
   put revDatabaseColumnNamed(tRecordSet, "Surname") into field "Name 
List"

then I just get a single record showing up in the list field.