Question Do not Save Record when I Toggle or change form

[knoxvillage]

Hello!

I am making an information system as a work for school. My problem is I want for changes in a record only be saved if i click in a button but at the moment if I change form or record without clicking the button it saves the record anyway.

Anyone can tell me how do I make it not save the record until the button is pressed?

Thanks in advance

 

[rainman89]

Your form is bound to a query, that is why you are saving no matter what.

Search the forum for a save button. You should be able to find a solution.

 

[MStef]

Look at this thread,
http://www.access-programmers.co.uk/forums/showthread.php?t=192859

 

[ghudson]

My old A Better Mouse Trap? sample should give you some ideas on how to do it.

 

[rainman89]

My old A Better Mouse Trap? sample should give you some ideas on how to do it.

Can you post that in code snippets or samples? I went looking for it and couldn't find it!

 

[Mage-7]

Lets say you have TextBox1 and TextBox2.

Create Close form button and disable close button near minimize and maximize buttons.

By default expression builder add two lines to your form close button:
OnError Goto Next
Close Prompt

You'd want to insert one line between these two...
Now on inserted line type:

In Condition field you should type:
IsNull(TextBox1) = False Or IsNull(TextBox2) = False

Action:
RunCommand

Arguments:
Undo

Now why you need arguments? Well Try delete that argument, save one record and on blank fields press Close button and you'll see how access sucks out your saved record out of table.

 

[gemma-the-husky]

the real thing is to understand why access saves the record, work WITH it, and be happy in this ....

control the user activity by suitable validation checkes in the forms before update event.


the only real alternative is to use an unbound form - which carries a lot of additional complexity.