I want the Start Time to be disable if the user already click on it. I added a Combobox4 but if the user change the details on combobx4 for example from completed to Pending, the Start Time button shows Enabled again. please see file.
Your ComboBox4_Change calls CHECK_INPUTRFP which starts with
Me.CommandButton5.Enabled = False
and second to last line is
Me.CommandButton5.Enabled = True
Private Sub ComboBox4_Change()
CHECK_INPUTRFP
If Me.ComboBox4.Value = "Completed" Then
Me.Frame1.Enabled = True
Me.Frame1.SetFocus
End If
If Me.ComboBox4.Value = "Pending - Team Meeting" Or _
Me.ComboBox4.Value = "Pending - 1st Break" Or _
Me.ComboBox4.Value = "Pending - Lunch Break" Or _
Me.ComboBox4.Value = "Pending - 2nd Break" Or _
Me.ComboBox4.Value = "Pending - Coaching" Then
Me.Frame1.Enabled = False
INIT_FORM1
End If
CommandButton5.Enabled = False
End Sub
... after that Your 'Start Button' will work as You wrote.