Refine combo box search

[sly like Coyote]

I've noticed an issue with an unbound combo box I'm using for a search; it's set up to pull the autonumber ID based on a last name search. The combo box has a select query search with the ID, last name, and first name included.

The search works fine as long as there's only one person per last name, but as soon as I have John and Joe Smith, the search itself only brings up Joe. Now, after the autocomplete the user can use the dropdown or arrow keys to get the right Smith, but it's invisible in the search box.

I don't necessarily need the first name to be searchable, but I DO want it to show in the combo box as Last Name, First Name without having to use the dropdown . I've checked the display settings and it all seems fine, but clearly there's something I'm missing.

 

[CEH]

If I read it correctly your just wanting to see these fields in the combo.....
Go into design... properties of the combo....under "Format" then "Column Widths" you will see something like...... 0";1";0"..... or whatever your shows... change the zero to a width suitable to view the name.... The first "0" will remain a "0" unless you want to see the ID number.

 

[sly like Coyote]

If I read it correctly your just wanting to see these fields in the combo.....
Go into design... properties of the combo....under "Format" then "Column Widths" you will see something like...... 0";1";0"..... or whatever your shows... change the zero to a width suitable to view the name.... The first "0" will remain a "0" unless you want to see the ID number.

This is already set to 0";1";.5" and does what you'd think it would, but only when the dropdown has been used. Typing in the combo box only shows the last name.

Maybe I need to add the first name to the actually select search criteria...the full row source select line look like this right now:

SELECT IndividualLandlords.landlord_id, IndividualLandlords.p_lname, IndividualLandlords.p_fname FROM IndividualLandlords ORDER BY IndividualLandlords.p_lname;

 

[boblarson]

Combo boxes will ONLY display the first field that is shown (with the width set greater than 0"). And as such, it is the only thing that will match what is being typed. If you want more you will have to create a concatenated field for display instead of the individual names.