title: How to pass value from subform to mainform ms access
body: <p>I have a form with a subform (Datasheet view form).  When i click a row in subform, i want pass  that row value to text box in main form . In  subform even  wrote this</p>
  
  <pre><code> Private Sub Form_Click()
   MsgBox (Noloan)
   End Sub
  </code></pre>
  
  <p>But i don't know how to pass that subform form_click no_loan to mainform.textbox. Thanks for your help.
  Additional data:In my db , i have a table which consist field No,NoLoan,Name. NoLoan Field value as i wanna clicked .From that table i create a subform/datasheet view ,subform name is T_Loan1. Then I create Main Form, name is FindLoan2. In that main/parent form i create text box, called Text7, and put T_Loan1 in subform object at footer.</p>