Hidden command button & code to make it visible

[larochy]

Hi.....I have a hidden command button and when I choose the value "UNCR-E3"
from a combo box, I want the command button to be visible. Here's the code
I'm currently using and it's not working, any suggestions?

Private Sub SKU_AfterUpdate()
If Me.SKU.Value = "UNCR-E3" Then
Me.Command58.Visible = True
Else
Me.Command58.Visible = False
End If
End Sub

 

[Jeanette Cunningham]

Hi larochy,

debug the code like this:

Private Sub SKU_AfterUpdate()
Debug.Print "sku: " & Me.SKU
Debug.Print Me.Command58.Visible
If Me.SKU.Value = "UNCR-E3" Then
Me.Command58.Visible = True
Else
Me.Command58.Visible = False
End If
End Sub

Maybe there is a typo in the names of the controls or the vaule uncr-e3


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[larochy]

Thanks Jeanette, you're right, it was my typing problem.

Thanks for the reply.