I am using a form with a list box off different reports the user can run. Based of which one they choose, I run a query against an SQL 2000 database from vfp and return the results to a query, no matter which report they run, the query name stays the same. I have the SFQuery object on the form and a button to call it. It works great the first time. But after running the first report, they then run another one, and click the query button, it still has the previous filter (which the clear button removes) but it also has the fields from the previous requery. Is there a way to clear all that when they first click the button so SFQuery refreshes with the new field choices?
Thanks
Kirk