How can I have a command button to be deactivated by default and be active
upon clicking another button. And then have it become deactivated again upon
clicking another button (Reset button)?

Let me explain it a little better.

I have a "search" button that filters data. I then have another button
"Report" that generates a report of the search result. Then I have a reset
button that clears the filter. I want the Report button to be deactivated or
grayed out untill the search button is clicked. And then as soon as the
"Reset" button is clicked the "Report" button becomes deactivated again.
Please hit me with your genius ideas. Thanks in advance.