>I've come across a combobox situation that is new to me and I would appreciate a brief tutorial. The function is basically a lookup. My difficulty is that I want to store one field and display another. The situation is this:
>
>Maintable1 has an integer field to store employeeID.
>The combo.controlsource is maintable1.employeeID.
>The combo is populated from lookuptable.employeename and lookuptable.employeeID.
>The combo will display the employeename both when it is open and when it is closed.
>
>Is this possible?
The field you store is different from the field you show, right?
List two columns in the ComboBox RowSource, but set the number of columns (i.e., visible columns) to 1. Set BoundColumn to 2, the invisible column.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
