title: Get data into one form field based on another's field in access 2003
body: <p>I am trying to update existing form field based on another combo box selection.</p>
  
  <p>I have a DB with such relations: <a href="http://img696.imageshack.us/img696/7396/relationse.jpg" rel="nofollow">http://img696.imageshack.us/img696/7396/relationse.jpg</a></p>
  
  <p>I have a such form: <a href="http://img233.imageshack.us/img233/9758/getdata.jpg" rel="nofollow">http://img233.imageshack.us/img233/9758/getdata.jpg</a>
  Which Offers to select only existing IDs in database.</p>
  
  <p>All i want to do is when user selects (change) existing combo box "Filmas_ID" value, in nearby input box with value "Unbound" shows up data related to this ID (You know - Just for informative reasons). </p>
  
  <pre><code>(SELECT Filmas.Nosaukums FROM Filmas WHERE Filmas_ID = combo box "Filmas_ID" value; )
  </code></pre>
  
  <p>It looks very simple, but i had no success yet to get it work.
  Thanks for your help! =)</p>