Combo box-concatenate field and hide column

[Shaft]

Hi,

I have a combo box which is populated by a table with the fields ID, First Name and Surname. What I want to do is display the first name and surname concatenated and hide the ID column, but populate the field with the ID number.

Is this possible?

 

[KenHigg]

Sure. Base the rowsource on a query that concat's the names. Then make the first col the id fld, bind the control to it in the forms underlying recordsource and make the first col width '0'.

Make sense?

 

[Shaft]

Worked like a dream. Cheers

 

[KenHigg]

Cool -