Help with InStr() function

[George Too]

I have these statements which load the appropriate subform depending on the entry selected in a combo box.
The problem is that the function finds both strings to be the same and loads the wrong subform for the second statement. How can I make the function "see" the difference b't both statements?

ElseIf InStr(1, Brand, "Gourmet Supreme" ) Then
Me.childHigh.SourceObject = "subfrmColorsHigh_GourmetSup"
ElseIf InStr(1, Brand, "Gourmet Supreme Decaf") Then
Me.childHigh.SourceObject = "subfrmColorsHigh_GourmetSupDecaf"

Thanks,
George

 

[Mile-O]

Swap them round.

ElseIf InStr(1, Brand, "Gourmet Supreme Decaf") Then 
    Me.childHigh.SourceObject = "subfrmColorsHigh_GourmetSupDecaf"
ElseIf InStr(1, Brand, "Gourmet Supreme" ) Then 
    Me.childHigh.SourceObject = "subfrmColorsHigh_GourmetSup"

 

[George Too]

Thanks man, that worked!