J
jsoyster
I have a toolbar with common queries and forms to open on it. However, I
have different tiers of managers (Wing level, Group level, Squadron Level,
Flight Level, and Section Level) that access them, and they need to see
information at their level and below. Of course there are multiple groups,
squadrons, flight and sections.
When a person logs in a form (they can't change or edit) comes up that shows
their name, Access level, and separate fields to show what group, squadron,
flight, and section they fall under.
So, what I need is to figure out how the have a button on the toolbar to
open a query or form base on the person's access level and match it with what
tier they are in.
In a nutshell, how do I get a button in a toolbar to do an if statement?
Should I do a Macro, and how would I do that? Can I have the button do a
visual basic code, and how do I do that?
have different tiers of managers (Wing level, Group level, Squadron Level,
Flight Level, and Section Level) that access them, and they need to see
information at their level and below. Of course there are multiple groups,
squadrons, flight and sections.
When a person logs in a form (they can't change or edit) comes up that shows
their name, Access level, and separate fields to show what group, squadron,
flight, and section they fall under.
So, what I need is to figure out how the have a button on the toolbar to
open a query or form base on the person's access level and match it with what
tier they are in.
In a nutshell, how do I get a button in a toolbar to do an if statement?
Should I do a Macro, and how would I do that? Can I have the button do a
visual basic code, and how do I do that?