T
Tim
I have a subform in which I have to validate many fields, i.e., make sure the
user to enter data into a field before going to the next field. Since the
main form's name and the subform's name are very long, and there are many
fields that would have similar codes, I would like to create a function (or a
sub procedure) in the Module rather than writing codes in the subform's event
to avoid repeating codes. For example, in the form_exit event, I would call
this function to check if the value is Null and then go to the next field and
so on and then the function return the result to the calling form event. How
can I do that?
Thank you for your help.
user to enter data into a field before going to the next field. Since the
main form's name and the subform's name are very long, and there are many
fields that would have similar codes, I would like to create a function (or a
sub procedure) in the Module rather than writing codes in the subform's event
to avoid repeating codes. For example, in the form_exit event, I would call
this function to check if the value is Null and then go to the next field and
so on and then the function return the result to the calling form event. How
can I do that?
Thank you for your help.