Auto Save

[letsaccess]

I have Navigation Form with many Subform , and I want to Disaple Auto save so the data will not save till user press on save button because I have many problems because auto save, I know there is many solution here but I try some of them but I don't know which one is the best for me , I don't want MS Access to ask users everytime when they moving between the subforms "are you sure you want to save the changes" .

Thanks

 

[sneuberg]

When using bound forms I don't believe there's is anyway to disable the automatic saving done by Access. You could use unbound forms in which case you'd have complete control but that negates one of the major advantages of using Access; not having to write code to do the inserts and updates. I suggest you post the problems you are having with Auto save and try to resolve them.

 

[Ranman256]

Then you need to enter data into an unbound form.
Once all data is correct, the user must click a SAVE button. This will run an append query.

 

[The_Doc_Man]

The only way to handle this with a sub-form is to understand that you CANNOT block the save if there is a "create new record" operation and relational integrity has been enabled.

It might make your life more complex, but I concur that the only CORRECT way to do this in a parent/child relationship environment is to use unbound forms with a parent SAVE button. If you want to be able to create multiple child records from the same parent, then the CHILD form will ALSO need a separate SAVE button.

You are inviting a raft of trouble with a parent/child design and that deferred SAVE requirement. I know from experience. As the saying goes, "been there, done that, bought that T-shirt."

 

[letsaccess]

Really thanks for everyone , I don't know why this issue too much complex , so did you advice me to forget this and keep going with Auto save , to avoid more problems ?

 

[sneuberg]

Really thanks for everyone , I don't know why this issue too much complex , so did you advice me to forget this and keep going with Auto save , to avoid more problems ?

That would be my advice.

 

[The_Doc_Man]

Unless and until you become very comfortable with VBA and manual recordset operations, your particular problem is a bit difficult.

Note that without the sub-forms, this problem is less difficult. But if you need the sub-forms, we can't help much because it is the "nature of the beast."