validate change to field based on another field

[tagteam]

I have a form i would like to validate input on. The field UpdatedResponsibilityCode can be updated but it can only have certain values based on the PaymentResponsibilityCode. Is there a way to force this validation?



If UpdatedResponsibilityCode = 4 then PaymentResponsibilityID can not equal 1

Thanks

[tagteam]

To add more information:
This is a continuous form
I would like a pop up that describes the error (not just conditional formatting)
Would like it to not allow the change if it doesn't match the criteria

[ItsMe]

If Me.UpdatedResponsibilityCode = 4 then

      if me.PaymentResponsibilityID = 1 then
             msgbox "PaymentResponsibilityID cannot equal 1." & vbcrlf & _
                         "The value has been reset to 0."
             me.PaymentResponsibilityID = 0

                         if me.dirty = true then
                               me.dirty = false    'Save current Record
                         end if

      end if
end if

[tagteam]

Thanks, I will give that a try