Look "ahead" in a record set

[bknight]

It is pertinent because the last operation has to be calculated, otherwise I could do it manually, but that defeats the purpose of the code.

[bknight]

The solution is logic/code error. The line in question s/b

Code: Select all

ElseIf recData(8, I - 2) = "Exit" And recData(8, I - 3) = "Entry" And (recData(3, I - 3) + recData(3, I - 2) + recData(3, I - 1)) = 0 Then

The recData(3, I) check for a rec that is outside the four possible solutions and s/b recData(, I - 1).
Thanks for everyone's input.