title: MS Access, VBA, SQL... How to browse invoices
body: <p>I have a query that gives me the invoice lines of the last invoice for a certain customer. It looks like that:</p>
  
  <pre><code>SELECT * FROM invoicelines WHERE clientID = [forms]![frmClient]![txtClientID] GROUP BY invoice# HAVING DateSold = SELECT MAX(DateSold) FROM invoicelines WHERE clientID = [forms]![frmClient]![txtClientID]
  </code></pre>
  
  <p>It returns the customer's most recent invoice.</p>
  
  <p>What I want to add is a button that let me see the second most recent invoice, the third one, and so on.</p>
  
  <p>I know it's not that complicated, but I have been thinking about it for surprisingly quite a while with no idea surfacing.</p>
  
  <p>Thanks!</p>