sly like Coyote
Registered User.
- Local time
- Today, 00:36
- Joined
- Apr 14, 2010
- Messages
- 82
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.
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.