title: Access 2010: Selected record value from subform
body: <p>Thank you in advance for the help for this problem - it has been driving me mad. </p>
  
  <p>First of all: My question is regarding the how-to here: <a href="http://www.fmsinc.com/MicrosoftAccess/Forms/Synchronize/LinkedSubforms.asp" rel="nofollow">http://www.fmsinc.com/MicrosoftAccess/Forms/Synchronize/LinkedSubforms.asp</a>. </p>
  
  <p>I have a form in Access 2010 that contains a subform. The content of the subform is updated with VBA. Everything works great here. </p>
  
  <p>I want to be able to open another form based on the record, that the user has chosen in the subform. This entails knowing the number of the record selected by the user. To start with, I just what the ID of the chosen record to be written into a normal textbox in the form. </p>
  
  <p>I found the solution in the above-metioned link. It says: </p>
  
  <blockquote>
    <p>"To reference a value in a subform, use the following syntax for the
    text box's Control Source property:</p>
    
    <p>=[subFormName].[Form]![ControlName]"</p>
  </blockquote>
  
  <p>It works perfectly in their example (I have downloaded the .mdb and it works!), but when I try, the "[Form]" is not an option. And so, I cannot get it to work!</p>
  
  <p>I tried in their .mdb as well, and I cannot chose [Form] either, so as soon as I change the control source property of the textbox, it stops working. I have tried with [.Formula] instead, but nothing (link to screenshot: <a href="http://i.imgur.com/pR2WkSW.png?1" rel="nofollow">http://i.imgur.com/pR2WkSW.png?1</a>)</p>
  
  <p>What could be the problem? Maybe language settings? </p>
  
  <p>Thank you so much in advance. </p>
  
  <p>M. </p>