Hi!

I have set up a form with 2 Comboboxes 1- CustomerCombo 2- SalesRepCombo,

then used the after update event:

   Private Sub CustomerCombo_AfterUpdate()

      SalesRepCombo.RowSource = "SELECT SalesRepID, SalesRepFullName, FROM SalesRepCustomerQ" & _
                             " WHERE CustomerID=" & CustomerCombo & _
                             " ORDER BY SalesRepID ;"
  
   End Sub


if u have a look at the code you will see that the select statement is based on a query, the reason why I did so is: because my SalesReps are not directly related to the customers (see screenshot the relations),
to make it clear the customers are companies which have employees and sales reps are their employees, (and the database is an electric company who takes calls from companies so a company is for me a customer and when taking a call I need to keep track who of there employees contact us)  so I did not just put in in salesRepT the ID where they are employed because they might work at more then 1 company! therefore I built a separate table to make a one-to-many relation.

I built a query to put together the sales rep full name and the places where he works (which can be more than 1 place) so now I am able to use this query for my Combobox, but I want that the SalesRepCombo should be based on the CustomerCombo, but looks it does not work throwing out an error msg

Any solution?