Adam,
Crystal provided an excellent tutorial on using the combo box in the manner I think you need. I was asking if you had specific questions concerning the advice given. I understand that working with Access can be overwhelming in the beginning. However, it will not benefit you to have someone hand you the complete solution without some effort on your part to understand the proposed solution and to try to implement it properly.
One of the best ways to gain knowledge is trial and error. Try to analyze the advice and adapt it to your application... if/when you get stuck or need clarification, ask questions...Utter Access’ members will happily help you through it...
Des,
I believe we did have a conversation concerning all the Great People names William. But it's been a while. So if you care to stroke my ego, I'm all for it.