Hi All,
I have a search form which uses the Allen Browne code from here http://allenbrowne.com/ser-62.html.
The data I have linked to my form which the above code is using is from an Union query and the search generates the correct results.
I have used code from here http://btabdevelopment.com/export-tablequery-to-excel-to-new-named-sheet/ but it only exports all records from the Union query not just the results from the search, which is what I want to achieve. This maybe because you can’t use a Union query in this way.
How can I get the filter results from the Allen Browne code into the export to excel module/function?
Thanks.
Mark
I have a search form which uses the Allen Browne code from here http://allenbrowne.com/ser-62.html.
The data I have linked to my form which the above code is using is from an Union query and the search generates the correct results.
I have used code from here http://btabdevelopment.com/export-tablequery-to-excel-to-new-named-sheet/ but it only exports all records from the Union query not just the results from the search, which is what I want to achieve. This maybe because you can’t use a Union query in this way.
How can I get the filter results from the Allen Browne code into the export to excel module/function?
Thanks.
Mark