Francis
If you use objects for your recordset .. you can oRs:CLose() and then oRs:Open() with a new query and then oLbx:ReFresh() .. just do not reassign oRs .. leave its properties intact.
Rick Lipkin
a less complicated solution is to open the SQL alias with different alias used by xBrowse and assign it.