required if certain data is chosen in combo box

D

deb

I have a form (Financials) with 2 combo boxs. (DescID and DescriptionSub)

If DescID 58 is chosen, I would like to make the DescriptionSub field a
required field.


How can this be done?

Thanks
 
W

Wayne-I-M

If Me.DescID = 58 And IsNull(Me.DescriptionSub) Then
MsgBox "You must enter a value for DescriptionSub"
Me.DescriptionSub.SetFocus
Cancel = True
End If
 
Top