title: Using a select query to source values from joined tables
body: <p>I am trying to source a value in a form from the table in the code below 'tblJobTitles'.  The value I would like to source is the value 'JobTitle' Unfortunately, in the control box i keep getting #Name? error. I am trying to adust the properties but everthing i try gives me the same error.</p>
  
  <p>Note: if i attempt to do this without joining 'tblContacts' to 'tblJobTitles' and using only 'tblContacts', I can successfully retrieve the job title in the field on the form, only that it returns the numerical unique ID number from the job title table.  Is it possible to reformat it to return the text value?</p>
  
  <pre><code>sql_get = "SELECT tblContacts.*, tblJobTitles.* FROM tblJobTitles INNER JOIN (tblContacts INNER JOIN tblTeams ON tblContacts.Team = tblTeams.ID) ON tblJobTitles.ID = tblContacts.JobTitle WHERE [tblTeams].[team]= '" &amp; cboDepartments.Value &amp; "'"
  Me.frmstaticdatadepartments08.Form.RecordSource = sql_get
  </code></pre>