Dear All,

     I have a Combo Box (Combo2) and some values are stored in it.I also have a Button (Get Details).When the form is Loaded, this button will not be enabled.Only when we select any value from the said Combo, this button will be enabled. I wrote a

 when running the application, I am getting a error message. Is this code correct? The combo contains Numbers.

Any one who gives an help in this matter will be appreciated...............

 Nanda Kumar

Hi,

Try this

Private Sub cboCompNo_Change()
 If Combo2.SelectedIndex <> -1 Then
    Command2.Enabled = True
 End If
End Sub

Tried this code. But not successful....Any other way by which I can accomplish this task....




Nandan

I think you should try changing the code in

Private Sub cboCompNo_Change()

If not isnull(Combo2) Then
    Command2.Enabled = True
else
    Command2.Enabled = False
End If

End Sub

I'm not sure about this, but give it a try...

Sorry, change it to

Private Sub cboCompNo_Change()

If not isnull(Combo2) Then
    Me.Buttonname.Enabled = True
else
    Me.Buttonname.Enabled = False
End If

End Sub

if it is the action button you want to enable...

I'm being to quick here...

make sure you put the code on the after update event of the combo box where you select the values...

hi
sorry for a delayed reply..

try this..

Private Sub Combo2_Click()
   If Combo2.ListIndex = -1 Then Command1.Enabled = False Else Command1.Enabled = True
End Sub

Regards,
Raghu

hi,

Change event of the ComboBox will fire, when start typing in the textbox portion of the ComboBox

Click event will fire whenever u select any item from the combobox dropdown.

ListIndex is the property which will return the index of the Selected Item in the ComboBox, if no item is selected it will return -1.

This is the reason why all code that u've tried didnt work

Regards,
Raghu