Hi all,
I am creating a Form that will control several queries that will sort various noun modifiers in a parts table. The form will have around 10 separate queries that are available to the user. To run each query, all you do is press a command button. In the command button "Property Sheet" under the "Format" tab, I noticed the presence of several categories that allow me to change the look of the command button once it has been pressed. I figured hey great, just what I want, but of course there is a catch. The command button only changes color during the actual time the command button is pressed. How do I get the command button to retain the pressed colors after the button is pressed?
In other words, I have a list of command buttons a user can select in the form, I want them to select the buttons and have that button change color and stay that color so that the user can see that the button has been selected and thus there is no need to select again, unless of course they want to due to changing some criteria that is associated with that command button from other areas of the form.
Of course I'm new at this, so if it is a long dragged out process with a macro that is longer than text message, I may just bag the entire color idea.