Data auto save problem with sub form

[deepaksharma]

I am using following code to prevent access to autosave data, unless I press save button.
Form top
Code:


Private SaveRecord As Boolean

Form Current
Code:


SaveRecord = False

Form Before update
Code:


If SaveRecord = False Then
Cancel = True
Me.Undo
Cancel = False
End If

cod on Save button (on click)
(along with other fields conditons)
Code:


SaveRecord = True

This works fine without any problem for one form (without subform).
Problem:
But I have problem, when I have subform


With above, If I jump to subform, data filled in Main form is deleted.
If I dont use above code, data of main form is saved before I type something in subform and then confirm to save records by pressing save button.
(I can undertand, the code before update is deleting Mainform records, but solution?)

How can I solve this issue to add data of Mainform and subform at the same time, after I press save button.
1) Prevent the main form to autosave
2) meanwhile I can add data to subform
Finally press save
Note: I dont want yes/no popup messages for confirmation.

[Minty]

The short answer is no.
As soon as you move to the subform Access will attempt to save the record on the main form, which triggers your automatic dismissal of the main forms data.
The answer would probably be to not enable the subform (when you are on a new record) until the main form record is saved.

I would delete your other 2 posts, no need to ask the same question three times.

[Welshgasman]

Please do not crosspost the same question, here or in other forums.
You might think you will get more attention, but likely would be the opposite.

Crosspost is frowned upon in most forums.

[deepaksharma]

ohh sorry i does not know about three times rules.

[deepaksharma]

can you please provide me a sample access file of this with simple coding.....please

[Bob Fitz]

can you please provide me a sample access file of this with simple coding.....please

Have you read Minty's comments in post #2

[Welshgasman]

Do not use the Undo command, just use Cancel?
However you are now working against Access and not with it.

[deepaksharma]

but i want the data not to be saved until the save button is clicked

[Welshgasman]

but i want the data not to be saved until the save button is clicked

I believe the Cancel will do that?
The Undo undoes the changes, hence it's name.

[deepaksharma]

can you please provide me a sample file of this with simple coding

[Welshgasman]

can you please provide me a sample file of this with simple coding

You have what you need, just remove the undo.

[deepaksharma]

if i do this then whenever the form will be closed without completing it will auto save in the data table which i don't want i want the data to be saved in the table when the save button is clickrd

[Welshgasman]

How is it going to save the data if you issue cancel all the time?
Have you walked through your code to test?

[deepaksharma]

you are right. my coding perfectly work with a single main form but it disturb when i use a sub form with this.

[Minty]

So set the Subform to enabled = false or hide it until they press save?
There is no point be able to enter or save subform data if you aren't going to save the main form data.

You can check on the current event if it's a new record, and if not enable or display the sub form.