**ComboBox Values**

[MS_Access_Amature]

I have a ComboBox with a ValueList ("Employee1";"Employee2") and Button1

How do you disable Button1 only when Employee1 is selected from the ComboBox??

 

[aman]

Try the following code:

Private Sub Combobox1_AfterUpdate()
Button1.visible=false
End Sub

 

[MS_Access_Amature]

That hides the button when either employee is selected.

 

[aman]

Try it:

Private Sub Combobox1_AfterUpdate()
if combobox1.value="Employee1" then
Button1.visible=false
end if
End Sub

 

[MS_Access_Amature]

If Me![ComboBox].Column(0) = "Employee1" Then
Me![Button].Enabled = False
Else
Me![Button].Enabled = True
End If

 

[MikeLeBen]

If you want the button grayed out but still visible, try:

Private Sub Combobox1_AfterUpdate()
If Me.combobox1.value = "Employee1" Then
Me.Button1.Enabled = False
End If
End Sub