SteveL13
asked on
Trying to get message box to appear
I'm using the following code to attempt to get a message box to appear but it doesn't appear when I select "Referral from associate" from the combobox.
??
--Steve
??
Private Sub cboComboBox_AfterUpdate()
If Me.cboComboBox.Column(1)= "Referral*" Then
MsgBox "This is a referral"
End If
End Sub
--Steve
ASKER
Jim,
I did your suggestion. What I see when I hover over the If... Then line is what I expect...
"Referral from associate"
And then I "Step Into" and it just goes to the End If line. Doesn't stop at the MsgBox line.
I did your suggestion. What I see when I hover over the If... Then line is what I expect...
"Referral from associate"
And then I "Step Into" and it just goes to the End If line. Doesn't stop at the MsgBox line.
ASKER
Almost like the wildcard code is wrong.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That was it. Thanks.
Then execute and see what's in column (1).
My guess is your off one column, because columns are zero based (first column is 0) unlike the settings in the property page, which start at 1 when setting things like bound column.
Jim.