Can I get the values for a drop down list from an Access table or
pass-through query instead of a worksheet so the data they are picking is
directly from the database?

I need a spreadsheet that people can use to enter in their employee number
and the element to which they should get paid (sick, vacation, regular hours
etc..) without them typing in the wrong employee number or pay element, so I
figure a drop down list would be best.