title: Access vba modify query def to change columns displayed?
body: <p>I'm using the CurrentDb.QueryDefs object to alter the sql in my query.  This works well, until I change the select clause.  I want the query to now show only the fields named in my new select clause.  Instead, the column headers are still showing, but there are no values.  I'm displaying the query in a subform.  </p>
  
  <p>How can I force the subform/query to only show the specified columns that can change on a button click?</p>
  
  <p>REASON: This is an advanced search form where checkboxes represent each field, and the user can remove and add fields each time they search.</p>