Disable subform if your not admin user

bseche

Registered User.
Local time
Today, 06:24
Joined
Aug 13, 2001
Messages
26
I have a form with a subform. I want the subform to be only available to the admin users. It's kind of like Hidden the subform and then if it's admin make it available.
 
Is your database secured or do you have another way of identifying an Administrator?

Cheers,
SteveA
 
Why not have two forms, one with and one without the subform. Just make the one with the subform available to the administrator.
 
Good idea saintsman
In reply to SteveA
I don't have the security setup yet. I have about 50 people that will be accessing the form. 2 out of the 50 are admin users.
I'm planning on setting it up so when they launch the database it asks for user name and password. If the user is admin it will allow them to view the subform.
 
In VBA you can make a field visible or hidden by setting its Visible property to True or False. For a subform, you might have

Me.SubformName.Visible = Administrator()

Administrator() could be a program or a field that identifies if the current operator is an administrator.

HTH,
SteveA
 

Users who are viewing this thread

Back
Top Bottom