stop DBNavigator from saving changes when going to next record
I have a bunch of DBeditboxes that are in edit mode and a DBNavigator which navigates through all of my records. I only want my user to be able to change a record by clicking a specific button. I have that part working when you click the button I just post the data then put the form back into edit mode.
My problem is if you edit one of the edit boxes and then go to the next record it appears to be saving your changes in the database. This is a very unwanted behavior any idea on how I can stop that from happening?