Help with subforms before update event and making sure button on main form executes a

[rocket2011]

Hey there, I have one main form and 2 continuous subforms in my access project. All my forms have before update routine to check for null condition. The problem is i have a close button on my main form which works fine if the user clicks it while updating the main form. However once from the subform if the user clicks on this button, it does not execute the code since the subforms before update event keeps throwing the validation check error. How do i force the code behind my button to execute at all times??



---
regards angad

[ajetrumpet]

see here: http://www.access-programmers.co.uk/...d.php?t=204959

[rocket2011]

hey adam,

thanx for the help mate but that is just another thread of mine which i have posted on another forum ...hoping to get help or advice as early as possible ..since i am stuck with this since quite some days and need to make my deadline. i need my button to function exactly as how to default 'x' button functions in access, and forces to close the second time bypassing the before update event error!!

[rocket2011]

hey i got my problem solved from the other forum link above, thanx a ton though..

[ajetrumpet]

and even funnier, found here: https://www.accessforums.net/tutoria...wed-10278.html

But if you're thinking that you can use more than one person on more than one different forum to get what you need in the shortest amount of time, know this: I have written my own program to detect this stuff while I'm browsing the forum.

and Rocket, hey bud, no problem! You're certainly welcome! For what, I have no idea...

[rocket2011]

well now u can consider the thanx as teaching me basic forum ethics and not too sound too desperate i guess lol..