I am trying to get this function to work, but the "And" combining the two parts of the "If" statement does not seem to be working. The two Ifs, Isnull and Me.Activecontrol = work separately, but when combined by the "And", it only seems to check the first one. So as it is written below, IsNull is checked, but me.ActiveControl = is not. If I swap the order, then me.ActiveControl = is checked, but IsNull isn't. Does anyone know how to get this to work? Thanks.
If IsNull(Me.Test1) = True And me.ActiveControl = Me.Test1 _
Then
Me.TestResult1.value = ""
ElseIf me.ActiveControl = Me.Test1 And IsNull(me.Test1) = False _
Then
Me.TestResult1.value = me.ActiveControl * 1.2