This is my listbox,...This is my listbox on SQL!

[Randomblink]

SELECT tbl_ProjectBasics.Proj_ID, tbl_ProjectBasics.Proj_Num, tbl_ProjectBasics.Proj_Title, tbl_Department.Dept_ID
FROM tbl_ProjectBasics
INNER JOIN ((tbl_Department INNER JOIN tbl_Employee ON tbl_Department.Dept_ID = tbl_Employee.Dept_ID)
INNER JOIN [tbl_LINK_ProjectBasics-Employee] ON tbl_Employee.Empl_ID = [tbl_LINK_ProjectBasics-Employee].Empl_ID) ON tbl_ProjectBasics.Proj_ID = [tbl_LINK_ProjectBasics-Employee].Proj_ID
ORDER BY tbl_ProjectBasics.Proj_Num;

I am showing the connections between four tables below:
--------------------------------------------------------------
tbl_ProjectBasics.Proj_ID
- to -
tbl_LINK_ProjectBasics-Employee.Proj_ID
--------------------------------------------------------------
tbl_LINK_ProjectBasics-Employee.Empl_ID
- to -
tbl_Employee.Empl_ID
--------------------------------------------------------------
tbl_Employee.Dept_ID
- to -
tbl_Department.Dept_ID
--------------------------------------------------------------

Well, I am using this SQL code as the ROWSOURCE for a listbox.
I want to Display ALL the Projects from tbl_ProjectBasics...

BUT

I want to have a combo box on the form where the ROWSOURCE is the tbl_Department...
Then, if you select a Department, it will use that as criteria for the one listed above...

Can you help me...?

 

[RichMorrison]

Brian,

Do a search of this forum on "cascading combo boxes". You will find lots of threads and examples where you chose an entry from combo box ONE and use the value as a parameter in combo box TWO.

This seems to be one of the most popular topics in this site.

RichM