title: Toggle sort order with a command button
body: <p>I'm using </p>
  
  <pre><code>DoCmd.SetOrderBy
  </code></pre>
  
  <p>for sorting a form by a specific field. But right now it sorts ascending or descending if I use <code>DESC</code> keyword. How can I do a check to see what sorting is active and do the opposite? If that field is ordered ascending and I click the button, the order become descending and vice versa.</p>