title: Detecting data changes with Form events
body: <p>If you've read my other recent questions, you've prob'ly picked up that I'm not <em>really</em> an Access developer.... Most of my background is in VB, where I assiduously avoided bound controls.</p>
  
  <p>Now I'm working in Access 2007. I have form that's based on a table (well, a single-table query), and a subform upon it based on a one-to-many child table. I want to detect user-made changes in the data on either of these forms so that I can update a date stamp in the parent table. The actual date field is not being shown to the user (at least not here). </p>
  
  <p>What would be the appropriate event to catch the fact that the change has been made? How should I make the actual change (direct to form.Recordset!dateField | with a hidden bound text box | some other way)?</p>