MS Access 97: set rowsource of list to recordset

Hi:

I currently have a search form which works but I would like to improve on it. Currently, the user enters the search criteria, clicks a command button, VB creates an SQL string, runs the SQL, spits the results into a table (first a delete is run, then the insert) and the list box displays the contents of the table. I tried to make the rowsource of the list box the SQL string but the string is longer than 255 characters so it is rejected. Can the list box be set to display the contents of the recordset that is created from the SQL? I tried Forms!Search_Pubs!lstSearchResults.RowSource = rs but there is a conflict of types. I tried !RowSource instead of .RowSource but object is not a collection.

Any suggestions?

Make a query and put the query in as the row source of the lsit box. The your statement can be a large as you want it and it won't matter.

just remember the listbox.requery to referesh you query to base on the new data in the table

S-