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.
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?
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.
Code:
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?