franksirvent
Programmer
Hi there
I have an Access form which creates a formatted Excel report when a button is pressed.
It all works nicely, however the Excel sheet has a Combobox which filters the data on the sheet depending on the selection made.
When the report is created, all records are shown and I would like to (from Access) select a value of the combobox, then run the Combobox_CHANGE code.
Is there a way of doing this ?
thanks in advance for your help
I have an Access form which creates a formatted Excel report when a button is pressed.
It all works nicely, however the Excel sheet has a Combobox which filters the data on the sheet depending on the selection made.
When the report is created, all records are shown and I would like to (from Access) select a value of the combobox, then run the Combobox_CHANGE code.
Is there a way of doing this ?
thanks in advance for your help