>I set m.RecNo to the current record number. Then a filter condition happens where that particular record number is no longer available. What is the best way to get to the next previous record number that is available? Or should I just do a LOCATE and not worry about it.

I think we had some code for this, but it was long ago and I don't have this code now.

Perhaps you can put goto statement in try/catch and do locate in catch block.