Bind Combo Box to Specific Field 1

[DeLaMartre]

Elementary question from an elementary Access user:

How do you specify which field/column you want to draw from for a Combo Box item? I don't understand how to do this using the properties.

For example, when I choose an "Employee" table to use as the source for a combo box dropdown, I end up getting the primary field entries, rather than the desired employee name which is in the second field.

Any help will be greatly appreciated!

Thanks very much,

-Bob in California

 

[mgolla]

To see the name change the column count and widths setting

ColumnCount = 2

ColumnWidth = 0";1"

This will hide the primary key field and show the name field if the name field is the second column

HTH
Mike

 

[DeLaMartre]

Thanks for the quick, concise reply, Mike! Your time is appreciated!

Regards,

-Bob in California

 

[matethreat]

Along the same lines how would you show multiple columns.

 

[mgolla]

Like this:

ColumnWidths = 1"; .5"

ListWidth = 1.75"



HTH
Mike