Preventing data to change when text box value is changed

[jera]

Hey guys!

A form displays information on a construction site in various text boxes. I want to enable the user to change this information but not until a save button is pressed.
Now I have the problem that as soon as I change the value of a text box, the data in the database is updated.

Is there a way to prevent these updates but still get the text fields to be linked to the attributes of a table?

 

[Estuardo]

G'd Afternoon Jera,
I'm not aware if that's possible, but a workaround could be to duplicate all your textboxes and "hide" the bounded ones showing just the unbounded. At the button click you will need to copy each unbounded to the bounded.
There may be many other ways but this one seems easy to implement. Let's wait for more comments from other members.

G'd luck.

 

[JHB]

Another way is to create a temporary table with only the one record in you want to edit, and then open a form with the record source set to this temporary table. Or set the form's record source you already have open, too the temporary table. And when you want to save the change then run an update query.​