Greetings fellow access users!
I am creating a new form and I'm having issues finding a correct data validation formula to meet my needs. I have a combo box on my form that gives a user various options to select that indicate the status of a part. One of the options is "On Hold". If a user selects this option, I want them to fill out the "comments" text box to indicate why.
If a user selects a different status from the combo box, then it is not mandatory that they fill out the comments section.
Thank you in advance for any help that you may provide!