IF Statements

[soldat452002]

Hello,

I have a form that has two fields that create a condition for another field, It works when I use 1 statement alone, not two . Any ideas why? Thanks


Private Sub Jurisdiction_AfterUpdate()
If Jurisdiction.Value = "California" AND BusinessUnits.Value = "M" THEN

CaseID.Value = " "

End If

End Sub

 

[leanpilar]

do you try both or only one?
If Jurisdiction.Value = "California" then works?
If BusinessUnits.Value = "M" then works?
if bth works try
If (Jurisdiction.Value = "California") AND (BusinessUnits.Value = "M") THEN
if not, I had a similar problem when I store the data in table with looukp field from another table and the data stored was 1,2,3,4 and not what it show in the form field.