title: Fetch Value from Listbox Datasource
body: <p>I have a list box that is data bound to a accdb file and is display the contents of one column, the dataBindingSource that it is linked to has also been filtered - this works fine (but may effect what I'm about to ask).</p>
  
  <p>I would like to know how to pull a value from the selected items full record, for example. The list box currently displays the surname - that is all you can see, how can I pull the customers forename which isn't displayed but does exist within the data bound source?</p>
  
  <p>This is the code used the populate the list box:</p>
  
  <pre><code>    public frmCustomer(string Input)
      {
          InitializeComponent();
          this.customersTableAdapter.Fill(this.dSSystem.Customers);
          this.catsTableAdapter.Fill(this.dSSystem.Cats);
  
          // Display Customer Record
          int lvRecIdx = customersBindingSource.Find("AccRef", Input);
          customersBindingSource.Position = lvRecIdx;
  
          // Fetch Cats Owned
          catsBindingSource.Filter = ("CustRef = '" + Input + "'");
      }
  </code></pre>
  
  <p>Thank you</p>