title: Several If Statements in an access 2007 vba subroutine. Curious if there is another way?
body: <p>First let me premise with I am very new to access vba.  </p>
  
  <p>My question is I have several if then else statements in a row for example</p>
  
  <pre><code>If Me.txtRevenuePerHour.Value &lt; 90 Then
      Me.chkRPH.Value = -1
      Me.chkRPH.Enabled = "False"
  End If
  
  If Me.txtLoadTime.Value &lt; 0.25 Then
      Me.chkLT15.Value = -1
      Me.chkLT15.Enabled = "False"
  End If
  </code></pre>
  
  <p>I was wondering if there is another way besides rewriting the if statements over and over again.  If not then I will accept that but just curious if there is another way.</p>
  
  <p>The if statements check a checkbox control if certain conditions are met.  Most are different conditions but some are the same </p>
  
  <p>Thank you ahead of time</p>