>>For some reason the replace code below seems to send my file pointer to the last rec.
>>I was at top (got INFOBASE open in browse window as I go thru debug)
>>I scrutinised every command and no movement.
>>As soon as the replace happened I saw the browse shoot to eof()/bottom
>>I've reindexed the table (which always has a CDX open anyway - no IDX)
>>
>>

>>Select INFOBASE
>>Replace DAYS_OP with Thisform.cOpDays
>>

>>
>>Anyone any ideas what the kinell's going on here? I'm not sure this always happens as some have been successful.
>>
>>'ppreciate it
>>
>>Terry
>
>Did you have index based on DAYS_OP and that order is current for the table?

Hi BB

Thanks for getting back.

There is quites a complex index in operation:

rte_no + rte_let + directn + var_code + days_op + j_start

Note that Days_op is part of it. However the value of Days_Op has not changed so I don't see how this would change the order.

Having said that you've just prompted me to consider what would happen if I did!

Do you still think this might make a difference?