Hi,

I once had to deal with a problem like your's. From my point of view the best solution is to recreate the query each time the user makes changes by creating the query out of several strings. These strings should contain values from the listboxes you mentioned. For instance:

"Select * from " & listbox1.list(listbox1.listindex) & " where " & listbox2.list(listbox2.listindex) & " like " & listbox3.list(listbox3.listindex) & " order by " & listbox4.list(listbox4.listindex)

Then requery your recordset using the newly created query. This should work fine.

I hope I've helped you out...