title: MS Access 2010 VBA Combobox
body: <p>i am new to programming field for MS Access and VBScript.</p>
  
  <p>I have a question that need help from here.</p>
  
  <p>first of all i have 2 tables in my MS Access database.
  1 is Web, 1 is Owner.
  Relationship is 1 to many (1 web can have multiple owners)</p>
  
  <p>I have a form which consists of 3 comboboxes.
  combobox1 is use for webURL
  combobox2 is use for ownername1
  combobox3 is use for ownername2</p>
  
  <p>So, how can I make combobox2 and combobox3 to display the ownername1 and ownername2 respectively when I select different webURL (in combobox1).
  Furthermore, this combobox2 and combobox3 drop down list must include all the ownername in table Owner (So that i can change the ownername to other person of that particular web when i click the button update)</p>
  
  <p>Now i only able to populate webURL data into combobox1.
  The rest i have no idea how to do..</p>
  
  <p>Here is the sample data:</p>
  
  <p><strong>Web Table</strong></p>
  
  <p>follow the format</p>
  
  <p>webID (PK), webURL</p>
  
  <p>1          Stackoverflow.com</p>
  
  <p>2          Google.com      </p>
  
  <p>3          Yahoo,com</p>
  
  <p><strong>Owner Table</strong></p>
  
  <p>follow the format</p>
  
  <p>ownerID (PK), ownerName, webID (FK)</p>
  
  <p>1 Law 1</p>
  
  <p>2 Hans 1</p>
  
  <p>3 Kent 2</p>
  
  <p>4 Howard 3</p>
  
  <p>5 William 3    </p>
  
  <p>Your help is very much appreciate in here.</p>
  
  <p>Thanks!</p>