Question Validating a field based on the selection of another field

[adewale4favour]

Hello!,
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

 

[Ranman256]

answered at: https://www.accessforums.net/showthread.php?t=78555

 

[adewale4favour]

thanks, but what I need is, users who select other options are free to proceed, but users who select LENOVO must select year else they should not be able to proceed.
the above option has been tried, only the sql query was not exactly this way, but most alike....

 

[pbaldy]

I would use the before update event with code that implements your requirement:

http://baldyweb.com/BeforeUpdate.htm

 

[arnelgp]

do it on the Form's BeforeUpdate event:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If [Type].ListIndex = -1 Then
    Cancel = True
    Msgbox "You need to select Type from combobox"
    Me.[Type].SetFocus

Else
    If [Type] = "Lenovo" And [Year_Release].ListIndex = -1 Then
        Cancel = True
        Msgbox "You need to specify the release year!"
        Me.[Year_Release].SetFocus
    End If
End If
End Sub