That's what I'm going to try next. I've never used RowSourceType of fields before so didn't even consider that.
>Hi Nigel,
>
>Use a rowsourcetype of Fields (6) and then in the rowsource list the fields in the order
cursorname.description,lookupcode>
>Cheers,
>
>Andrew
>
>
>
>>I will be using it if the user changes the description or other details in other controls on the form. Or if they add a new row. I just need the combobox to ignore it. I will have a look at putting the fields in the RowSource instead of the cursor name, in which case I will be able to put just the lookup and description.
>>
>>>Nigel
>>>
>>>Then you are right to use column 1 as the bound column.Don't even bother putting the PK in the rowsource.
>>>
>>>Whats the PK for if you don't use it ?
>>>
>>>Nick Mason