Help with combo box lookups

  • Thread starter Thread starter David C. Holley
  • Start date Start date
D

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
 
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
 
Back
Top