I have a form shwong a list of stock 1 record at a time.

I have set up a combobox which displays a list of "itemID"'s which is the Primary key for the table.

Using the above approach I can successfully search the form.

The problem I have is that the ID numbers are meaningless to the user so I need to put "itemDescription" in the combo with "itemID" in the itemvalue property.

I cannot get this to work.
Does anyone have any suggestions or examples on how to do this???