Hi Joe,

>But I need to show the description B for each A. My problem now is how do I show both A and B in the drop-down list and still keep only A in the controlsource?

Either you could do a SELECT A+B, A and set bound column to 2, or SELECT B, A and do the same, it should display the first column and the controlsource will be set to the 2nd invisiable column. Let me know how it works and if youe need more help.