>>>>Hi Daniel,
>>>>
>>>>Did you read the original question? :) I don't do inserts, I do replace command. Your code will not help me.
>>>>
>>>>Thanks anyway :)
>>>
>>>Hmmm...should have read it with both eyes open, eh?
>>
>>Hi Daniel,
>>
>>Anyway, you got me thinking :) I came up with some idea, though quite combersome. Before do replace I'll call thisform.DetermineNextRecord() method.
>>In this method I would open BldMstr table and save recno of the next record in a form property (or just return it), then do my replace, then move to the record, which should be next.
>
>That's about all I could come up with, too...although you could do something like this in the replace method itself:
>
>
>* assuming you are in the table that you perform the replace in
>lcCurrRec = recno()
>skip
>lcNextRec = recno()
>skip -1
>if lcCurrRec = recno()
> * perform the replace
> GOTO lcNextRec
>endif
>
Yes, it's almost the same, except I need another copy of the table (use table again) to make this check. I can't navigate in the original table, because it may cause come unwanted effects.
Anyway, the problem is resolved, thanks to you, but I changed my mind :) and decided not to jump to another record, and seat on the same. Once I decide to return back to the original idea, I'll use this code.
Thanks again.
If it's not broken, fix it until it is.
My Blog