Hi Jason, thanks for the reply.
I didn't explain the full picture in my question as I thought your answer would point me in the right direction.
This recordset that populates the dropdown also has an email address associated with each subject. My idea being that you can choose a subject and that email would go to a specific recipient. Bearing in mind the full picture is there a way to do it all? Like "What's your query to do with?", "Sales", OK then choose "Sales" and the form will be submitted to the sales department.