-snip-
>>Yes, that works but it is not my situation. What I need is to save another value than the value showed in the listbox. That is the same way as if I would use a SQL as described in my original reply. So, basically, the values are entered manually but I need to save another value.<<
Michel,
Try using RowSourceType = 5 - Array. Fill the array in the init of the combo.
~~Bonnie