Editing form control except when closing form

[EddieN1]

I have a subform with a required field as the first field. There are only 4 valid values. I have the values in a combo box so that if something is selected, it must be one of the options. However, if the operator hits tab or puts the mouse on another field, the "not in list" doesn't trigger. I tried added the edit to the "On Exit" event but then it triggers when the operator just wants to close the form. How can I require a specific set of values (null is not valid) but not trigger if the operator is just closing the form? Thanks for your help. Eddie

[June7]

NotInList event only runs if there is code in it and if LimitToList property is set to Yes.

If the field requires data then user must select one of the values or the record committment will fail and error will trigger. If you want to allow user to abort new record, that is another issue.