Logical statement on a Switchboard

[iholder]

Is there way to use logical statement on a switchboard.

Example: Not allowing user to access a certain switchboard, if option is
clicked.


Thank
Ileana

 

[Arvin Meyer [MVP]]

Is there way to use logical statement on a switchboard.

Example: Not allowing user to access a certain switchboard, if option is
clicked.

Certainly. You can disable any control on a form based on an option group or
any other control. Use the after update event of the option group to disable
the button which opens the switchboard. You may also need to call the same
code in the current event of the form.

 

[S.Clark]

I think Switchboard is table driven. Perhaps add another column with a
security level (e.g. 1-3, where 1 is highest). When the switchboard opens
restrict the items, via a query, based on the security level. So, if UserA
has Security level 1, then they can see 1-3. If UserB has SL2, then they
only see 2-3, etc.

Else, suppose that clicking on a switchboard option opens a form. In the
form, perform a security check then allow/reject the form opening.