I am wanting to select an option from one combo box and then have it change the available options in another combo box?

I have created three tables Companies, Employees, and Issue.
In all three tables I have added CompanyID as a common factor.
In the Employees table I have a field called Name.
In the Issue table I have created combo box field called company name where the source is the companyname field from the companies table . In the same table I have created a combo box field called contact whereas the source is the Name field from the employees table.
What I am trying to do is create a form from the Issue table where the Company Name field and Contact field are inserted in the form however, when I select a company from the dropdown in form view of the issues table the contacts field will have a dropdown only showing me the contact from that particular company only that I can select from.
Can anyone help me with coding this? I am trying to do an SQL query an here is what I have maybe I am wrong.

Select Name
From Employees
Where Companies.companyid = Employees.companyid

I have to be missing something because it is not working. =(


EB


EB

__________________
EB

Here is what I have done in the past...

Combo 1 is the first one you would select from.

On the OnClick event for Combo 1 have it do Combo2.Requery

For Combo 2, have the record source as a SQL Statement, but with a WHERE clause that references Combo 1.

Below is an example of 1 I did a while back.

SELECT tblSubData.SubData, tblSubData.SubDataID, tblSubData.SubDataParent FROM tblSubData INNER JOIN tblData ON tblSubData.SubDataParent = tblData.DataID WHERE (((tblSubData.SubDataParent)=[cboCombo1].[Value])) ORDER BY tblSubData.SubData;

Hope that helps - If not yell!

Mike
EchoVue.com

I will try that and get back to you.

thank you

eb

EB

Ok, once again you have saved the day. That worked. =)

EB

Good to hear!!

Mike
EchoVue.com