Hello folks!
I am working on a project where I want to have one user form with sixteen command buttons. These command buttons will change their caption based on the "user group" that is selected when the user entered the MS Access application. I would like to store a list of these command button captions in a table and control if the command button is visible. I figured I could do an "on form load" with VBA code that will loop 0 to 15 and find the user group, caption, visibility of each command button. The challenge is how to connect the action or "on click" trigger to match the button caption that has been assigned. Any ideas for that portion?
Thanks in advance for your thoughts and insight on this one.
-Shea