Combo Box Look up

[Musa via AccessMonster.com]

I have a Combo Box that lists Names. Each name can be in there twice. There
is a Id and a time id that identifies each record. How can I choose a
record from the combo box based on 2 identifers ?
For example, I would like to choose id 20 with time id =2 and have that
information display in the form...etc.

Id time id
20 1
20 2
11 2
15 1
15 2
30 2



Thanks

 

[Ray C]

The problem with your logic is that your Id field has duplicates and your
Time ID field also has duplicates. Realistically, you should have a unique
identifier for the records that are being displayed in your combo box and use
that as your bound field. That way, you simply display the value by using the
following code:

Me.MyComboBox = MyUniqueIdentifierValue

Ray