title: Updating a field in a related Table after Form Field Update
body: <p>In my database, I have two tables I am working with that are related. The first table is the Offer Information table (OfferList). The second table is a journal more or less of the progress of the offer (Ledger). The OfferID is referenced in the Ledger Entry. However, since there are multiple entries for the same offer in the Ledger, I have an EntryID that references a specific entry. Both forms have a field called status. The status of each Ledger.Entry does not change but the status of the Offer does change based on the last entry. I need Access to automatically update ONLY the OfferID.Status based upon the Ledger.Entry I am currently working with in my form. I.E. I use a form for Ledger.Entry that has HLID, Date, Status, Notes. Once I am done with the Ledger.Entry and save/update the Ledger table, I want the Offer.ID.Status to update to whatever I put into Ledger.Entry.Status on my Ledger form. The catch is I ONLY want to update the record in Offers that I am currently working with. I suspect that I will be using VBA to accomplish my goal. HL# is linked to HLID.</p>
  
  <p>E.G.</p>
  
  <p>OfferList</p>
  
  <pre><code>HL#     Status    Agent    Buyer
  ID01    Presented Jim W.   Roger R.
  ID02    Failed    Jim W.   Wilma S.
  ID03    Accepted  Jeff H.  Roger R.
  ID04    Accepted  Andy K.  Peter P.
  </code></pre>
  
  <p>Ledger</p>
  
  <pre><code>EntryID  HLID  Date      Status
  01       ID03  04/05/13  Presented
  02       ID03  04/07/13  Accepted
  03       ID02  04/04/13  Presented
  04       ID02  04/04/13  Failed
  05       ID03  05/05/13  Closed
  </code></pre>
  
  <p>When I enter that last row into Ledger, I want the Status in OfferList for ID03 to update to Closed.</p>