Hi!
If this is a table - well better of you use a query...
The idea is simple - query the Street field twice. First field is editable and you display it in the grid. Second field is read-only and used by index only for search. This way when you change the street the field order will not change until you requery the data.
>Hi Vlad,
>
>Seems like I didn't explain the problem well. Ok, I'll try again:
>I have a table with index set. I change one of the fields, which index is based on. Now I'm not at the place, I was before, but in the different place in the file. E.g. I was on streets starting by "A", I changed one street to start from "T" and when I press Next\Prev button, I'm now on "T" letter in the file. I want to still be on "A" to continue my work...
>
>Thanks in advance.
>
>>Hi, Nadya!
>>
>>It is not clear for me what is the problem. What means 'I want to remain on A'?
>>
>>>Hi everybody,
>>>
>>>I have the following situation: I have a grid with ability to edit couple of fields. The table has an order set to Situs (upper(ccode+town+Street+str(Snum,4)+StNumExt+Unit). Suppose, user changes street from Aitlor (typo) to Tailor. Now when he/she presses the next/prev button on the navigation bar, he/she moves to another position in a table. I want to remain on A. It doesn't matter, if I have editable grid or editable textboxes, the problem exists for both cases, though grid case seems to be more complicated.
>>>
>>>Do you have ideas, how to save the current context?
>>>
>>>Thanks a lot in advance.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.