Hello!,
I am a new member in this group, and great to be here. I am Michael.
I will appreciate getting assisted in figuring this out.
I have a form with two Combo boxes, both are dependent. Now what I want to achieve is, Example, in Combo Box A TYPE, I have options like HP, Lenovo, Dell etc, and Combo box B, I have options like YEAR: Released 2003, Released 2005, Released 2008 etc. Now, I want users who select Lenovo to be mandated to select the year of released. If other options are selected, they can skip the year of released.
I thought this could be done from the Validation rule, I used this line of Validation([TYPE]="LENOVO" And [YEAR_RELEASED] Is Not Null) Or ([TYPE]<>"LENOVO" And [YEAR_RELEASED] Is Null))
This isn't working.
thanks