undesired Invoice Number change on Order table.

[ManuelLavesa]

MYDATABASE1.zip Hello all, I enclosed my database because it is very difficult to explain what is happening. The problem is as follows: If you go to the table Orders, there is a field named InvoiceNumber. This field has values from 0 to 11. Now if you go to the main Form and select "Edit Sale Orders" Enter a value from 1 to 11 the form will open for that Invoice Number. Then close the form and go back to the table "Orders" and you will see that the "InvoiceNumber" field which was 0 now contains the value that you entered for the search before. It always affects the record that is on the top of the Order table. I don't know what is causing this. If any body can figure this out I would really appreciate. Thank you all for your time and ideas.

[CJ_London]

without needing to look, the control you are using to find an invoice should be unbound

[ManuelLavesa]

Hello Ajax you are a genius, yes it was bound... I don't know some times I forget the obvious... Thank you for your help again. Problem solved