title: VBA/Access: Track the last date a macro was run via a command button
body: <p>I'm using command buttons to import excel files into various tables, and I want to track the last time each table was updated (i.e. the last time the command button was clicked and ran successfully).</p>
  
  <p>I've tried doing this by adding a text field next to each command button, and then adding <code>Me.TextField1.Value = Date</code> to the <code>_Click</code> subroutine for each button. This fills in the date correctly, but it doesn't save the value when I close the data base. </p>
  
  <p>How do I keep the date value from resetting every time I reopen the database?</p>