I am trying to disable the controls on a form and keep coming up against "Auto_logo()"
1) what is it?
2) how can I bypass it?
My code below
1) what is it?
2) how can I bypass it?
My code below
Code:
Public Function lockAll()
Dim frm As Form
Dim ctl As control
If UserLevel = 3 Then ' "userlevel" is set in a login form
Set frm = Screen.ActiveForm
For Each ctl In frm.Controls
If InStr(ctl.Name, "btn") = 0 Then
ctl.Locked = True ' stops students from altering data
End If
Next ctl
End If
End Function