title: How to update field on one table based on field in another table in MS Access 2010
body: <p>Good morning,</p>
  
  <p>I'm designing a database in Access 2010 to track inventory. It specifies a bin location for each item that is tracked. Each product will always associated with one bin, and no bin will be associated with more than one product (but can be associated with 0 products). Products may move to a different bin at any given time, and I need to be able to search/filter/etc. by either bin location or product name.</p>
  
  <p>Currently, I have a form that will display several different fields for one record (product) at a time. In it I've included a combo box whose control is a query that provides a list of all empty bins. This combo box will be used to select a bin location for a product, and updates the <code>[CurrentInventory].[Bin]</code> field. When <code>[CurrentInventory].[Bin]</code> is updated I would like two other tasks completed as well: </p>
  
  <ol>
  <li>Update <code>[Bins].[AName]</code> with the same value contained in
  <code>[CurrentInventory].[AName]</code> where the value of <code>[Bins].[Bin]</code> is the same as <code>[CurrentInventory].[Bin]</code>.</li>
  <li>Clear the previous value of <code>[Bins].[AName]</code> in the record where
  <code>[Bins].[Bin]</code> equals the previous value of
  <code>[CurrentInventory].[Bin]</code>. This is so the previous bin will show as empty and become available for another product.</li>
  </ol>
  
  <p>I'm not very experienced with Access yet, and have limited experience with both Macros and VB, so I appreciate any suggestions!</p>