Hi,
Is your OrderHead table buffered? If so you can check for OldVal() for the No. field (look this up in the Help). If the user isn't adding a new record then the old value can be restored to the 'changed' field before your program moves to the new record that is wanted.

If you are not using buffering, then save the original value in a form property and restore it from that.

HTH
Barbara

>Hello People
>Please help me out
>
>Here's my situation
>
>I have a parent child relationship between 2 tables
>
>1> OrderHead
>
> No.
> Party
> Date
> SalesMan
>
>2> OrderDet
>
> No.
> Item
> Qty
> Price
> Value
>
>These tables are in the dataenvionment of the OrderEntry form with their BufferModeOverRide property set to OptimisticTableBuffering
>
>
>The form has all fields bound to the respective textboxes.
>I have a grid for the OrderDet Table with filter set to show records maching the current order No. in OrderHead Table.
>
>I want the user be able to add an order just by typing in a new order no. But if he enters an old order no then he should be shown the old order for editing. But ...
>
>BUT ..
>
>But when the user overtypes the OrderNo he should be prompted to save changes if he had edited the data but if he was adding a new record then the new appended record shuld be removed from the table.
>
>My problem is than when i overtype the OrderNo and then save the old edited record when prompted then my OrderNo is changed to the new typed in value. I dont want this to happen ..
>
>How do I prevent this from happening.