title: MS Access After Insert Macro
body: <p>I've been automating a process at work.
  I use an Access database (2010) and it's working real nice.</p>
  
  <p>For my questions the relevant tables are: Inorder and Exceptions
  Inorder: All the information in here goes in to an order, including a DeviceID and an exception column
  Exceptions: All the exceptions are written here, we need that in the inorder table with a DeviceID, Date and an Exception (description)</p>
  
  <p>When the Inorder table is filled, an update query runs updating every Inorder.Exception column with the relevant Exception (works perfect, no problems here).</p>
  
  <p>What i need is the following:
  When a user inserts a row in to the table Inorder the exceptions table needs to be checked and if there is an exception for the Date and the DeviceID in the Exceptions table the Inorder.Exception column must be filled.</p>
  
  <p>What I've searched:
  Using Datamacro's because triggers do not exist in Access 2010
  <a href="https://stackoverflow.com/questions/5623440/ms-access-trigger">MS Access trigger?</a>
  <a href="http://msdn.microsoft.com/en-us/library/office/ff973807%28v=office.14%29.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/office/ff973807%28v=office.14%29.aspx</a>
  <a href="https://stackoverflow.com/questions/9801744/access-after-insert-and-the-missing-id">Access, After Insert and the missing ID</a>
  <a href="http://office.microsoft.com/en-us/access-help/video-create-a-data-macro-VA100305331.aspx" rel="nofollow noreferrer">http://office.microsoft.com/en-us/access-help/video-create-a-data-macro-VA100305331.aspx</a>
  And several other Microsoft sites.</p>
  
  <p>I've tried multiple setups but it doesn't give me the expected outcome.
   I cant figure out how to get the relevant data from the Exceptions table to the Inorder table.
  I don't really get the GUI at all.... Could someone help me along?</p>