title: Detect new record and obtain ID using Access VBA
body: <p>Related to <a href="https://stackoverflow.com/questions/4402005/detecting-data-changes-with-form-events">this question</a>, how do I detect that a form user is adding a record? It would be ideal if I knew this as soon as the form's "current record" became "new" (navigating beyond the last existing record, or clicking the "new" navigation button), but knowing as soon as the first piece of data begins to be entered would be almost as good. I'm guessing that this would be testing <em>something</em> in <code>Form_Current()</code>, but what (or is there a better way)?</p>
  
  <p>Further related, what is the earliest that I can find the (Autonumber) ID for the new record? That requires a save, does it not? Is it automatically populated into the form's recordset?  (I know this is <strong>not</strong> the case for code-driven saves <code>.AddNew ... .Update</code>.) The reason I'm asking for this is to begin populating the child table behind the subform (the data is such that I can auto-create a "default" data set that the user can confirm or modify).</p>