title: How do I prevent a linked field and subform from editing my table in Access?
body: <p>I have a Date Field and Subform linked by Date (pick a date, all records from that date show up in the subform.) </p>
  
  <p>My problem is that when I pick a date, the most recently accessed record is CHANGED to that date... </p>
  
  <p>I've tried setting Allow Edits on the subform to No but that didn't work. I've fiddled around with a few of the other options to no avail. Is this a simple solution to a simple problem? I have another form with a Date Field and Subform that works just fine, but that one has everything (edits, additions, deletions) set to No.</p>
  
  <p>My ultimate goal is to display all records on a subform by date and delete the selected record.</p>
  
  <p>Thanks!</p>