title: MS Access: Making a subform field combo box populate with data from separate table?
body: <p>I'm trying to convert a form previously made in an old Excel to something that can be used in current versions of Access. The Excel version has a feature where values put in a field in one table can be referenced to be used as values in another table. Ex:</p>
  
  <p>Table A: Name Field has values {Joe, John, Lisa, Mary, Max}</p>
  
  <p>Table B: Click on name field, values to choose from {Joe, John, Lisa, Mary, Max}</p>
  
  <p>I'm attempting to replicate this in MS Access with subforms connected to tables. My current set-up is:</p>
  
  <p>Table A: Name Field has values {Joe, John, Lisa, Mary, Max}</p>
  
  <p>Table B: Name field connected via Lookup Wizard to Name Field in Table A</p>
  
  <p>Subform: Table B displayed in subform. Name field of Table B is a combo box.</p>
  
  <p>I want the combo box to drop down containing the contents of Table A's Name field. However, when I click on that combo box, I simply get an error noise and nothing happens.</p>
  
  <p>I haven't attempted any coding, as I'm not well versed in VBA, so there may be a better way.</p>
  
  <p>If this isn't enough information, I'll try to provide more.</p>