Hi Guys,

Anybody know how to make the combo box (Linked to another table) show the Code and Description fields, but then SAVE the PK ID field?

Would make my life so much easier.

Cheers

Row Source: SELECT tblName.ID, tblName.Code, tblName.Description FROM tblName
Row Source Type: Table/Query
Column Count: 3
Bound Column: 1
Column Widths: 0cm;3cm;3cm (adjust as required)