Thanks for the replies. I have it working in part now, but the result in the second combo box is showing the area and not the business name. How do I get BusinessName in the second combo box? My code is :
Dim sContracorSourc e As String
sContractorSour ce = "SELECT [ContractorDetai l].[BusinessID],tblArea.area,[ContractorDetai l].[BusinessName] " & _
"FROM tblArea INNER JOIN ContractorDetai l ON...

Hi there, this question has probably being asked many times, but it has got me stuck.
I have a table for customers that includes a control for the area that they reside in.
There is also a table for contractors that shows the areas they work in. A table called tblArea has the only two options, "North" and "South" which is linked to the customer and contractor table. The customer can only select one option but the...