title: Show MS ACCESS Tables using ComboBox Selection
body: <p>Need your help. I'm a student and I am doing a <code>VB.Net</code> program for my Accounting class project. Now, I have little knowledge about using <code>OleDB</code> so I'm gonna need your help please.</p>
  
  <p>Here are the details:</p>
  
  <ol>
  <li>Database is <code>MS ACCESS 2007</code>(<code>OleDB</code>)</li>
  <li>Database Tables are <code>tbl_login</code>, <code>tbl_product</code>, <code>tbl_transaction</code></li>
  <li>Forms are <code>Form1</code>, <code>Form2</code> and 1 <code>Module</code></li>
  <li><code>ComboBox</code> Values are <code>Users</code>, <code>Product</code>, <code>Transaction</code></li>
  <li>Language is <code>VB</code></li>
  </ol>
  
  <p>As the I run the program, a Log-in form (<code>Form 1</code>) will appear and will require username and password. As the user submits his username and password, the program will check if it matches in the database table named <code>tbl_login</code>. If it matches then proceed to next form (<code>Form 2</code>). Here, a <code>ListView</code> and a <code>ComboBox</code> is present. As it loads, The Default content of the listview are the contents of <code>tbl_login</code> and combobox value is <code>Users</code>.</p>
  
  <p>Now, what I want my program to do is that when I changed the combobox value to <code>Products</code>, the listview items will be the contents of <code>tbl_products</code> and when combobox value is <code>transaction</code>, <code>tbl_transaction</code> contents will appear in the <code>listview</code>.</p>
  
  <p>How will I code this one?</p>
  
  <p>I would really appreciate all your help. Thanks.</p>