Access User Level Security

[Vaidhy]

I am new to Access VBA,please kindly help,
I have a database that has a Main form with 5 subforms in it.
I have a users table with name,password and permissions as 'All','Edit','Read','None'.
Basically i need to implement a user level security.
when he database is opened , a login page opens at startup containig Username and password .
Based on the user logged in,how do i enable/disable fields in the main form ?

 

[DCrake]

On the forms onload event use either an If statement ore a Select Case statement.

If ULS = "LOW" Then
   Me.Control.Enabled = False
End If

 

[Vaidhy]

On the forms onload event use either an If statement ore a Select Case statement.

If ULS = "LOW" Then
   Me.Control.Enabled = False
End If

Hi DCrake,
I can understand what ur implying,
But when the main form is loaded,how to imply to access tht which user is currently logged in ?

 

[DCrake]

When the user logs in you need to store their access level somewhere, ie public variable or control on a hidden form and use this as your indicator.