Enable and Locked (1 Viewer)

[CanWest]

I need to be able to set the Enabled and Locked properties of all fields in a form based on someones security level

I know I can do this

    If Forms!frm_LogonStorage!SecurityLevel > 51 Then
        Me.FirstName.Enabled = True
        Me.FirstName.Locked = False
    Else
        Me.FirstName.Enabled = False
        Me.FirstName.Locked = True
    End If

The only problem with this is I would have to do this for about 50 fields. Is there a way to do this for the entire detail section of a form. I have searched this forum but have not had any luck

 

[bob fitz]

You could set some code to loop through all the controls and determine if the control is a text box. Then run you code to set the enabled and locked properties.

 

[bob fitz]

Take a look at the following thread: http://www.access-programmers.co.uk/forums/showthread.php?t=165872

 

[gemma-the-husky]

 dim ctl as control
 for each ctl in me.controls
    if whatever then
    end if
 next

 

[CJ_London]

if this applies to all the controls on the form, why not just set the forms 'allow edits' property to false

 

[CanWest]

if this applies to all the controls on the form, why not just set the forms 'allow edits' property to false

That would have worked but there were a few controls I did not want have affected.

 

[CanWest]

Take a look at the following thread: http://www.access-programmers.co.uk/forums/showthread.php?t=165872

That article was awesome. Learned a few tricks I will be putting to use in many projects. Thanks