Ok guys! My brain is just swirling after reading other questions and answers. I have a form that is used to enter quarterly inventory dates. Each quarterly date (a text box - [Qtr1Date1] for example) also has 2 corresponding combo boxes - a change reason [Qtr1Date1Reason] and a change initiator [Qtr1Date1Changer]. I've made an AfterUpdate event that changes the value of the two comboBoxes to a default value - "<Select>" and it also changes the color to direct the user's attention there (but we all know that I need a requirement of data entry).
The piece that I cannot wrap my head around - if the user does not drop down to the first combobox and then the second and make an entry - how and where do I enter the validation requirement of choosing values? I only want a msgbox to pop up if they don't enter a choice in each drop down (I don't care which order they enter the choices). Do I need a validation save button? Or can this be done when user attempts to close out of form? Maybe SetFocus if value is = <Select> ?