• Home
 · 
• Custom Controls/Forms/Menus
 · 
• Create a function that will disable command button in all form... Works 100%... plus 1 for accessin

Create a function that will disable command button in all form... Works 100%... plus 1 for accessin

Create a function that will disable command button in all form... Works 100%... plus 1 for accessing this code....

Rate Create a function that will disable command button in all form... Works 100%... plus 1 for accessin

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

   FrmCtrl Me  
End Sub

'Copy and paste this code in a module
Function FrmCtrl(FrmName As Form)
   Dim ICtrl as Control

   For Each ICtrl In FrmName.Controls
     If TypeOf ICtrl is CommandButton Then FrmName.ICtrl.Enabled = False
     'If... another Control goes here....
   Next
End Function