Hi all, i have 2 unbound text boxes costA and CostB and 1 bound text box rate in continuous form. now i am writing vba code to get rate value depending on costa and costb values.
if costa and costb values are null then rate = 0
if costa has value then rate = costa or
if costb has value then rate = costb
please note that in continuous form we will be having either costa or costb value. we don't have both values same time. one value will be always null
whatever code i am trying to modify it is either working for costa or costb but not for both.
If (IsNull(CostB) = True And IsNull(CostA) = True) Then
Rate.Value = 0
ElseIf (IsNull(CostB) = False And IsNull(CostA) = True) Then
Rate.Value = CostB.Value
Rate.Value = CostA.Value
can someone tell this is happening because of continuous form?