Cascading Combo Boxes don't work

[binghamw]

I can not get cascading combo boxes to work. I have looked at many different examples but none of them seem to work for me. I want to have one combo box where you select the department. The second combo box selection will be filtered from the first combo box. The second combo box will have a list of all the files available to view (in the department you selected). After selecting the file you want from Combo box 2, I want a new form to open with all the information on that particular record to show. (This new form will only display the information for the record that was selected).
I am having problems getting this to work. How do you make the second combo box dependant on the first (Is this possible if they're reading from different tables, or does one need to be reading to a query?). Then, how can I display all the information about that particular file either below that in the detail section, or in another form?

 

[dcx693]

If you've looked through the examples on line and you still can't get it to work, perhaps you can post a subset of your database and we can try to help you out. If you haven't already read it, this is a good article: Cascading Lists for Access Forms

 

[binghamw]

Okay here it is. Sorry it's a bit messy, it's getting rather complicated.

The form I am trying to get to work is called:

"frmresultsdepttest"

Combo box 1 is called: Comboseldept

Combo box 2 is called: Comboselfile

I have made a query called "qryresults" which can be used if needed. Otherwise, there is a table called "Department" and a table called "Layers".

Basically I just want "Comboseldept" (combo box 1) to list all the departments, and "Comboselfile" (combo box 2) to list the files depending on the choice from department selected.

Below that I would like the records that I put in there to show up as to whatever file I selected from Comboselfile (Combo box 2).

If you could have a look at that would great. I can't think anymore I'm getting so frustrated.

 

[binghamw]

sorry i had to make a new database because it was way too big.

 

[binghamw]

I have actually read the article "Cascading lists for Access Forms" and I downloaded the examples.

However, it shows me how to get the two combo boxes working, but not how to display the records from the second combo box in another form or in a subform below the combo boxes.

What is the code that I would enter for "After Update" for combo box 2?