I have a form that is somewhat based on this sample. I have the search working perfectly. Now I would like to take the search results and email, print, and/or save to a file (xls, html...). I have been able to set it up so I get the XLS file (to email or save), but it includes all the data from the subform (DataList_subform) instead of just the search results.
The way I have it set up now is by using a Macro and a button on the form to run the marco. My macro is:
OutputTo
Form
DataList_subform
Microsft Excel 97-2003 (*.xls)
The way I have it set up now is by using a Macro and a button on the form to run the marco. My macro is:
OutputTo
Form
DataList_subform
Microsft Excel 97-2003 (*.xls)