Vba code "Only for experts"

[deepaksharma]

@Jouneyman - you have picked the wrong event for your code, you need to do all the validation in the FORMS before update event, than you can issue a cancel = true and stop anyone leaving the form.
If you issue an Me.Undo it will undo the whole form.

Your idea of local temporary table(s) has already been discussed at length by two other responders and is almost as difficult to manage in a multiuser environment, when you take into consideration locking records being edited by someone else etc.

This is the second thread by the OP on this subject and he was finally coming round to accepting the limitations of his original approach, you are unfortunately covering old ground.

Minty, I have made some changes in the program as suggested by you. In this program, I have hidden the sub form. Now as soon as the user fills all the fields of the main form and clicks on the sub form button, only then the sub form will be visible and the main form's all text boxes will be disabled so that the user cannot make any changes to the saved data of the main form.
Now after filling the sub form, clicking on Save button will make the sub form disappear again and the form will open with a new blank record.
If any necessary changes need to be made to make it better, please give your suggestions.
Thank you.

[Minty]

I don't have time to look at the moment, but if it meeting your requirements then I would suggest you have solved your issue.

[journeyman]

@Jouneyman - you have picked the wrong event for your code, you need to do all the validation in the FORMS before update event, than you can issue a cancel = true and stop anyone leaving the form.
If you issue an Me.Undo it will undo the whole form.

You're right. I initially started with the form BeforeUpdate event, and somehow ended up with the text box. that's what happens when you're working from faulty memory in a thread.

The idea of a temporary table is for consideration in this thread only. I didn't read OP's other threads. OP has to consider his own logic to make it work. I'm merely contributing - take it or leave it.