On Error Resume Next
If Forms![frmAffiliateNameAndRegion]![txtSecurityID] = 9 Then
fncLockUnlockControls Me, True
Else
fncLockUnlockControls Me, False
End If
On Error Resume Next
If Forms![Switchboard]![txtSecurityID] = 9 Then
fncLockUnlockControls Me, True
Else
fncLockUnlockControls Me, False
End If
I don't understand what you mean by this?When I do it I can't even make a selection from a Combo Box. Wait, are you using the buttons? The code can't lock Command Buttons.