Background: In the MSFlexGrid application that I am writing, I have a For...Next search loop that searches every cell for a string input by the user. When there is a "hit" the record that contains that string is displayed in another MSFlexGrid.

Problem: Records in the database often contain several instances of the search string, so these records are displayed several times. I created a variable strComp into which I store the record that has just been found. I would like to compare it with the current search string variable strRow and if they match, exit out of the loop so that there is only one copy of each record displayed instead of multiple copies. What is the proper syntax for such an expression? VB6 won't accept anything I've tried.

Thanks,
-Bob Smythe