>>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.
If it's not broken, fix it until it is.
My Blog