In my subform, I want to required entry in the END_DATE field if the field Status ="Complete"
So far the code will continue to take the user back to the END_DATE field and prompt for a date as long as the Status is complete --- *except* if the user just closes the form. They'll get the error message three or four times, but eventually can close the form without entering the required information.
How do I keep the main form from closing when the required data is not entered on the subform?
Thanks in advance.
So far the code will continue to take the user back to the END_DATE field and prompt for a date as long as the Status is complete --- *except* if the user just closes the form. They'll get the error message three or four times, but eventually can close the form without entering the required information.
How do I keep the main form from closing when the required data is not entered on the subform?
Thanks in advance.