Adding filter to query

  • Thread starter Thread starter Ken Warthen
  • Start date Start date
K

Ken Warthen

I'm trying to export to excel the filtered results of an underlying query on
a split form. In the on click event of a command button I create a querydef
and then use transfer spreadsheet to create an Excel workbook. The code
creates the spreadsheet, but it includes all the records. I need to make it
create only the filtered records. I've tried several methods, but can't seem
to figure this out. Any help will be greatly appreciated.

TIA,

Ken
 
Back
Top