I am using an audit trail in my database based on this http://www.fontstuff.com/access/acctut21.htm
. It captures the current user with Environ. Now I also need to restrict or hide the Medical tab in this employee database for confidentiality reasons. There are only about 4 people who will have full access so I wonder if there is a way to hide this tab for all users except the few that need access? I could code it directly into the module or maybe create a table that lists certain users with administrator level? Suggestions anyone? Thanks in advance!
I am using a navigation form so the path to the tab control will be a long one.