In VBA I have created a simple method to hide/ show content based on user type using an unbound field (usually hidden in the underlying form) - "Me![Version]"
Code:
'SetversionMe![Version] = "Usertype3"
If Me![Version] = "Usertype1" Then
Me![NavigationButtonManagementReports].Visible = False
End If
If Me![Version] = "Usertype2" Then
Me![NavigationButtonManagementReports].Visible = False
End If
If Me![Version] = "Usertype3" Then
Me![NavigationButtonManagementReports].Visible = True
The issue I'm having is that this this is used across multiple forms to control visible content and for each I have to manually code in the the User type in VB editor before creating a release version for that user type.
Is there a way to set the UserType once (using a form or table) for Me![Version] which can then be referenced for user type across all form class VB objects?
Thanks Graham