Help with combo box lookups

[David C. Holley]

Pardon me, but I'm having a complete brain fart here...

I need a combo box where I can enter the item id (ex: 15) and having the
coresponding item name apear in the combo box and saved in the record
that I'm editing. Help please.

David H

 

[AlCamp]

David,
(use your own names)....
Put ItemID in column1 of the combo, and ItemName in column2.
ColumnCount = 2
ColumnWidths = 0";1.5"
The ControlSource for the combo = [ItemID]

Now, you will "select" an ItemID, the combo will "display" the ItemName,
and the combo will "store" the ItemID.

hth
Al Camp