ComboBox selection to perform an action (1 Viewer)

[5hadow]

Hello everyone!

I'm having some problems with my combo box selection. I need to select an item from drop-down combo box and depending on the selection perform an action. In this example, a simple message box with yes or no.

Private Sub cboReview_AfterUpdate()
    DoCmd.Save
    Me.cboReview.Requery
    If Me.cboReview.Selected(intCurrentRow) = 1 Then
        MsgBox ("Yes")
    Else
        MsgBox ("No")
    End If
       
End Sub

Combo box is based on a bound field from a table. It's in value list mode.

Problem is that it reports selection as 0 no matter what. Even if I select item 1, or 2 and so on. I threw in "Save" and "Requery" to see if it'll help. What is going on here?

 

[pbaldy]

Try

If Me.cboReview = 1 Then

 

[theDBguy]

Hi. Requery will probably reset the selection, so you should take it out. The Selected property is probably a boolean, so try using True or -1. Otherwise, just check the Value of the Combobox.