I have a table with 'Department' and 'Line Name', there are 5 departments and approximately 10 lines in each department.

I need to be able to select a department in the first Combo box, and then this controls what is available in the second Combo box. Therefore a user doesn't have too look through 50 lines in the box, only the 10 relating the selected department.

I have a table with Department and Line Name.
Can anyone help me!!

See my answer in the Queries section....

Jack