Dynamic Textbox Naming Not Working

My goal: Loop through a table, increasing row by i. When matching value is found, put value of BCX & i into a textbox called dest1. If BCX and i is empty, then BCW and i is used.
My problem: I have textboxes dest1 to dest15. When dest1 is populated from the table, then I want the next match to use dest2, and so on.
I tried the code below that I found, but I keep getting an error that closes Excel. The code looks very straight forward so I'm not sure what I'm doing wrong. It worked just fine until I tried the dynamic textbox names.
Any help would be greatly appreciated. This is a critical process to making my whole userform practical. Thank you. -Luke

    
For i = 2 To lRow 'number of rows in table
        For j = 1 To 15 'number of textboxes in the userform
            If Range("BCO" & i) = tn Then 'tn is the static number that is matched in the table
                If Range("BCX" & i) = "" Then
                    Me.Controls("dest" & j).Value = Range("BCW" & i).Value
                Else
                    Me.Controls("dest" & j).Value = Range("BCX" & i).Value
                End If
            End If
        Next j
    Next i

Untested by maybe this:

For i = 2 To lRow 'number of rows in table
            If Range("BCO" & i) = tn Then 'tn is the static number that is matched in the table
                j = j + 1
                If Range("BCX" & i) = "" Then
                    Me.Controls("dest" & j).Value = Range("BCW" & i).Value
                Else
                    Me.Controls("dest" & j).Value = Range("BCX" & i).Value
                End If
                If j = 15 Then Exit For
            End If
    Next i

6StringJazzer: lRow is the last row in my table. tn is a number that Im matching in the table. The code runs on initialize. It was working fine until I added the j loop to dynamically change the textbox name that receives the value from the table.

Akuini: did not work.

My error says that it cannot find the specified object. The textboxes are within 2 frames. The first frame is "outerframe". Within outerframe I have 15 different frames, each of them have the 15 different textboxes that I want to update. I tried the below code, but same error. Do I need to reference both frames, or just the frame that the textbox is in? Thanks. -Luke

    For i = 2 To lRow
        For j = 1 To 15
            If Range("BCO" & i) = tn Then
                If Range("BCX" & i) = "" Then
                    Me("frame" & j).Controls("dest" & j).Value = Range("BCW" & i).Value 'frame1 is in outerframe, do i need to reference outerframe too?
                Else
                    Me("frame" & j).Controls("dest" & j).Value = Range("BCX" & i).Value
                End If
            End If
        Next j
    Next i

You don’t need to reference the frame, what I was trying to say with the code I suggested is that your loop structure is wrong.
Could you attach a sample workbook?

So, ummm, I figured out my own retardation but am too ashamed to admit what it was. Akuini, your code works just fine - thank you so much.

To be fair to those who have similar dumb issue, please name your controls what you aim to call them in your code.
SMH, sorry for wasting anyone's time....

You're welcome, glad to help, & thanks for the feedback.