Microsoft Access
--
Questions
--
Followers
Top Experts
Conditional Hiding of Access 2010 Form Tab for certain users
I have a form that uses 10 tab forms. Â I need to open this form with a conditional value like 4 the will hide four of the Tabs so that certain user will not see them.
Attached is a screen shot of the Form. Â If a user has a user role of 4, this I want to hide tab 180, All, unassigned, and account trade request.
I thought of using an IF statement, but have not been able to get it to work.
Can any one help me with this?
tabs-form.JPG
Attached is a screen shot of the Form. Â If a user has a user role of 4, this I want to hide tab 180, All, unassigned, and account trade request.
I thought of using an IF statement, but have not been able to get it to work.
Can any one help me with this?
tabs-form.JPG
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Thanks,
I have a field on the form that holds the Value of the user role. Â I am using Access 2010
I'll Give this a try, tomorrow morning.
I have a field on the form that holds the Value of the user role. Â I am using Access 2010
I'll Give this a try, tomorrow morning.
Tried it this morning and it works great.
Thanks
DAvid
Thanks
DAvid
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Microsoft Access
--
Questions
--
Followers
Top Experts
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.