I only want the code to find and run on specific and if it meets the criteria for that row it goes to the next
This is the first criteria:Code:If rV.BOF And rV.EOF Then rV.Close Else rV.MoveLast rV.MoveFirst Do While Not rV.EOF rV.Edit For I = 1 To 3 For J = 1 To 4 K = Chr(J + 64) If rV![Toe Src] = "06236K300" And rV![Para #] = "0109" Then If rV![Bumper # / Plat ID] Like I & "PLT " & K & "/" & INFBN(I) Then Units = I & " " & K & " " & INFBN(I) rV.Update rV![Netbase] = Units rV.MoveNext End If End If Next J Next I
rV![Toe Src] = "06236K300" And rV![Para #] = "0109"
Unless that is met then it should skip everything
If met then it should look at
If rV![Bumper # / Plat ID] Like I & "PLT " & K & "/" & INFBN(I)
Example: 1PLT A/1BN2-222INF
It seems that it keeps running though all the variations for each line even though the criteria is already met. How can fix this?
Thanks
Yes I know the naming conventions are not correct due to spaces and the pound sign. Not my database.