CODEWITHSUNDEEP
vbams-accesscombobox
crimsonzero2
crimsonzero2

Reputation: 3

Microsoft Access Search Using A Different Column

I have a ComboBox that has columns: Name, Nickname, and Code in it. Currently, it is set up to search based on Name as the user types in the ComboBox when the user would prefer to type the Code instead. Is there a way to set it up so the ComboBox displays like it is originally set up while allowing the user to search using the Code column? I know that I can easily put the Code column in front of the Name column, but the user would like to keep the format the same.

Upvotes: 0

Views: 42

Answers (1)

Skippy
Skippy

Reputation: 1590

Simple answer: No. A combo box control will always search (autocomplete) the displayed value, which will be the first row source column with a non-zero width. The only way to achieve what you want would be to have two controls. You could have a combo box with Code as the first column followed by Name and Nickname, and then have a locked text box with Control Source set to =myCombo.Column(1)

Upvotes: 1

Related Questions