Nigel

if your controlsource is the PK and you enter the fields in the rowsource in the order mentioned by Jess then you want boundcolumn = 2 then the combobox will display the lookupcode and description of the appropriate PK from the lookup table.

Nick Mason