title: How to make subform display data according to combobox selection?
body: <p>I'm trying to bind multiple tables together and have a subform display data based on my combobox (ID name = CbproductName) selection in a form named Form2. I'm using Ms office Access.</p>
  
  <p>This is the query </p>
  
  <pre><code>SELECT Employee.EmpName, Employee.EmpCode, Employee.CompanyID, Employee.DeptID,
         Employee.ComputerID, Software.ProductName 
    FROM Software
         INNER JOIN (
               (
                Computer INNER JOIN Employee ON Computer.CompID = Employee.ComputerID) 
                INNER JOIN Application ON Computer.ComputerName=Application.[A-ComputerID]
               )
         ON Software.ID = Application.SoftwareID 
   WHERE Application.SoftwareID = Form2.CbProductName;
  </code></pre>
  
  <p>However it keeps prompting me to enter the parameter value when i run the form, and it doesn't display the result of the entered value. it also doesn't change according to the combobox selection.
  Can someone point me at a direction to get it done?</p>