title: How to pull text from the selected TextBox on a Report? VBA
body: <p>I have a Report (rptCourses) which contains 170 TextBoxes which contain Course names, pulled from an access Table (tblCourses). When the user clicks on one of the Course Name TextBoxes, a form (frmRateCourse) loads containing a TextBox (txtboxCourseTitle), essentially a header, which ideally would contain the Course Name of the selected Report TextBox. </p>
  
  <p>My question is: How can I take the text from the selected Report Textbox and input that text into the loaded Form's TextBox?</p>
  
  <p>I apologize if this question already exists! And thank you, in advance, for any assistance!</p>