I have a subform that is accessed from a main form. In the subform, I have a field that if the user selects "Yes" there are four other fields that need to be filled out (they cannot be empty).
I need to know:
a) What event do I attach the code to? (I need the code to execute whether the user moves to a different part of the application or closes the application altogether.)
b) Also need some sample code, if possible
Using MS Access 2003
Thanks so much in advance.