Combo Box Issue

[brandonze]

Hello again,



I have a form that uses a combo box to lookup a record. I have many names that are in the combo box list. All drawing off a query so I can get them in alphabetical order. However, say I type in smith and select the correct smith, lets say Jim, the record that populates will be Bob smith. I think this is becuase it comes before the other smith that I am trying to lookup.

Is there a fix for this?

[RuralGuy]

Do the records have a Primary Key?

[brandonze]

Yes. [ID] that is auto number

[RuralGuy]

If you used the wizard for the record lookup then it sounds like it is doing a .FindFirst on the last name instead of the ID.

[brandonze]

thanks. I think I forgot to include the ID in the combo box.