Access – drop down box for parameters

I’m looking for a way, in a parameter query, to present the user with a drop-down list of choices. So, for example, if the parameter is for a user’s department, the query would invoke a drop-down list offering “Sales”, “Service”, and “Accounting”, instead of the user having to type the department name at the parameter prompt.

If anyone can show me the code for this, I’d appreciate it.

C