Combo Box Name Selection

[Guest]

Hi. I have a Combo Box that includes the Last Name and First Name. When I
search for a record that has people with the same name i.e.-Smith, I can see
the multiple records, but when I try to select the record in the drop down,
it only displays the first record with the name Smith in the form.

How can I display the record that I select?

Thanks!

 

[Mark]

see the thread titled "Combo box NOT giving correct information!!! HELP" as
this was very recently asked.

 

[Guest]

Thanks. I'm learning as I'm going, created my Combo Box with the wizard.
Could you clarify:

1. How to set a bound column.
2. Where to type in the query.

I did find the column widths.

 

[Mark]

If your names table just had Firstname and Lastname, add a field called
RecordID, make it an Autonumber and make it the Primary Key. When you save
the table, it will assign a number to the records. Now, each new record you
add will have an ID number that uniquely identifies the record.

Then add a combo box to your form using the wizard. Add the RecordID,
Firstname and Lastname fields to the combo box. Since the RecordID is your
Primary Key, the wizard should default to using that field as the bound
field and will hide it so the combo box only shows the Firstname and
Lastname fields. The wizard will build the query for you as well.

 

[Guest]

Thanks for spelling it out for me! That works perfectly!