Combo Box

[cktcPeterson]

I have created a combo box on my form
Under row Source I have my desired fields
Name
Student ID

On the combo box, I want to select/type a name, but input the student id into the field.

Currently, I have in row source query
Name First (Ascending)
Student ID

I want to search by name and return the Student ID

I am able to see both columns

Thanks

 

[theDBguy]

I am able to see both columns

But did you want to see both columns? Make the name the first visible column and bind the combobox to the ID column.

 

[arnelgp]

is your combo bound?
set the Bound Column to 2.
set the Column Width to 1;0

 

[Uncle Gizmo]

You might find my Blogs on Combo Boxes useful:-

Combo Boxes - In the Beginning - Nifty Access​

Combo Box - Nifty Access

Combo Boxes Combo Boxes are the most fascinating and useful "Controls" you can have on your Form. They have Many uses. Combo Boxes can be manipulated in all sorts of ways without using VBA. Once you've mastered the combo-box, and once you have mastered Queries, the building of queries in the...

www.niftyaccess.com

Get Info From a Combo-box 1 - Nifty Access​

Display Data from a Combo Box in a Text Box - Nifty Access

Display Data from a Combo Box Combo boxes are one of the most valuable controls you can have on a form, they are so versatile and give you such an extra range of functions for your form that you should really consider understanding how to use them. Also with a combobox as your foundation, you

www.niftyaccess.com

 

[cktcPeterson]

It is still now working the way I hope for
My drop-down shows

Name Student ID

Which I want.

I want to type in the name, but returns the student id. Currently when I type in Mrs Ann, it show Ms Ann.

Thanks everyone for the quick response and help.

 

[CJ_London]

Don’t use non alphanumeric in field and table names - will cause unexpected errors.

with regards mrs Ann and ms Ann - do they have the same studentid?

if so it will choose the first one it comes to