F
fapa via AccessMonster.com
Hi there
I have a form (unbound) with a Subform which displays records of employees
and their share capacity.
On the form, i have 3 command buttons which act as filters to the subform.
When i click on a button (e.g. Employees with most shares) it displays all
the records (in decending order) of employees with the most shares (filtered).
I also have an excel button on the same form however, when I click on it, it
Exports the records on the subform - without the filter!
The code i've writen is:
DoCmd.OutputTo acOutputForm, "frm_options_issued_subform", acFormatXLS,
"frm_otpions_issued_list.xls", True
I understand that the code above says to display records from the subform
into an excel spreadsheet, however im trying to control the content/order of
the records (thru filters) but its not working
So overall, my aim is to be able to display the records in the subform in
Excel in an order depending upon what FILTER command button i press!
PLEEASE help!
I have a form (unbound) with a Subform which displays records of employees
and their share capacity.
On the form, i have 3 command buttons which act as filters to the subform.
When i click on a button (e.g. Employees with most shares) it displays all
the records (in decending order) of employees with the most shares (filtered).
I also have an excel button on the same form however, when I click on it, it
Exports the records on the subform - without the filter!
The code i've writen is:
DoCmd.OutputTo acOutputForm, "frm_options_issued_subform", acFormatXLS,
"frm_otpions_issued_list.xls", True
I understand that the code above says to display records from the subform
into an excel spreadsheet, however im trying to control the content/order of
the records (thru filters) but its not working
So overall, my aim is to be able to display the records in the subform in
Excel in an order depending upon what FILTER command button i press!
PLEEASE help!