John,

I'd leave the arrays like you have them. You'll have to fiddle with multicolumn cbos with one of the columns set to a 0 width. Using two arrays will let you just have the arrays already sorted .

Just setting the ControlSource for both cbos to the same field should allow the user to pick by either value.

>Each dropdown listbox has its own array... Could I use the same array for both and have a column 1 display in one and have column 2 display in the other and the third column my pk and both bound to the third column??? Waddauthink??