Serious Trouble. Please help...

[doran_doran]

Please help. I am in a serious crisis. Almost all the portion is done, excepts few.

I am attaching two database. The one with Bug is mine and the Security Original is my master copy that I downloaded from here.

When I load the form "frmrptinvidualdashboard" the
me.cboadmin.enabled=true and
me.cboadmin.locked=false

is not working for administrative access.

CAN ANYONE PLEASE VERIFY WHAT IS GOING ON.

Thanks
Download the DB from: http://www.utteraccess.com/forums/download.php?Number=512211

 

[Taff]

Hi Doran-Doran,

Try the following on the Open Event of your form:-

    If User.AccessID = 1 Then
        Me.cboAdmin.Enabled = True
        Me.cboAdmin = Me.cboAdmin2
        Me.cboAdmin.Locked = False
        
     Else
    'ElseIf User.AccessID = Int(4) Then
        Me.cboAdmin = Me.cboAdmin2
        Me.cboAdmin.Enabled = False        
        Me.cboAdmin.Locked = True
        
    'ElseIf User.AccessID = Int(5) Then
    '    Me.cboAdmin.Enabled = False
    '    Me.cboAdmin.Locked = True
    End If

HTH

Ant.

 

[doran_doran]

Did not work...

I think that is what I had in my original script. Let me know if you can think off anything else. Thanks

 

[doran_doran]

I Fixed It....

Thanks To Me... Yeahhhhhhh. I Fixed The Problem.

 

[Taff]

What was it?