Thanks for the post Fredservillon, but can you please explain further? I don't believe I need a WHERE statement because I want to select all rows in tbldepartment. Also, do I need to give the combo box some properties to find the database? I have a data control but it is set to sort on record. Let me know if you have any questions.
Ok, Assuming yur fldDeprtment records are unique you can use Data COmbo object for your drop down list.
This will give a drop down list of department names from your department table for user to select. I hope that's what you meant
Set adoDepartment = New Recordset
.Open "SELECT fldDepartment FROM tblDepartment", CNN, adOpenStatic, adLockOptimistic
Set dbcDepartment.RowSource = adoDepartment
dbcDepartment.ListField = "fldDepartment"