Use IS_MEMBER to capture role in MS Access

[KevinS1898]

Hi Everyone,

This is my first post to this forum and I am a SQL Server novice so I apologize in advance if this question is redundant (I did search forum but couldn't find an similar topic). I am not sure this is possible or not but what I want to do is determine if a user is part of a specific role and, if they are, either obtain the name of this role in the front end or add a value to control in the front end.

So far from books online I have this code using IS_MEMber in a pass-through query:

If IS_MEMBER ('WIP_Administration') = 1

What I want to do is have the code capture the name of this role in the front end, something like:

If IS_MEMBER ('WIP_Administration') = 1
FormControlInFrontEnd = MemberRole

is something like this possible...? OR... would it be possible to just assign an arbitray number to a field based on the users involvement in a particular role? Soemthing like:

If IS_MEMBER ('WIP_Administration') = 1
FormControlInFrontEnd = "3"

Any help would be really appreciated.

Thanks,
Kevin