title: Display data in combobox based on another combobox
body: <p>I have two tables:</p>
  
  <pre><code>'Project'
  Fields: ProjectID, ProjectName
  
  'Plans'
  Fields: PlanID, PlanName, PlanDate, ProjectID
  </code></pre>
  
  <p>In Access 2007, on a form, I have three textboxes that display information from the three fields in the 'Plans' table. I have a combobox to select a specific <em>PlanName</em> which changes the textbox values to match my selection.</p>
  
  <p>I want another combobox that displays all of the <em>ProjectNames</em> and then have the combobox that displays the <em>PlanName</em>'s change and only display those Plans where the ProjectID's match.</p>
  
  <p>I followed <a href="http://www.tek-tips.com/faqs.cfm?fid=4289" rel="nofollow noreferrer">this</a> guide but it didn't work.</p>
  
  <p>Would anyone give me a breakdown of what I need to achieve this?</p>