Combo box in subform (bound column)

[theKruser]

I have a subform that containes a combo box which is bound to a table other than the table the subform was created using. Not sure if that makes sense so:

tblPERSONNEL
tblPOSITION
qryPERSONNEL
-NAME
-EMPL#
-POSTITION
subPERSONNEL (based off query to return only personnel in certain departments)
-NAME
-EMPL#
-POSITION (combo box)

Here is my dilemma...I want the combo box to pull positions from tblPOSITION and display actual position name (not the PK) sorted by the PK value. In the properties I set bound column to 2 (position name is in column 2 as I look at the table view), but no matter what it only returns the PK.

The subform is in datasheet view, as this is how it must be for accurate data input as applied to my situation. I could easily just create another tbl with just the position names in the order I want them to appear and point the combo box to that, but then I have duplicated data and updating becomes a two step process if a position title changes (as the often do!).

Any help would be greatly appreciated. Thank you for your time.

 

[KenHigg]

Have you tried tinkering with the column widths?

 

[theKruser]

This answered my question, thank you. However, after tinkering a bit I figured out another way with less steps. In the video, do everything exactly like it says right until the time that you close the query you had opened from the properties box. Once you have selected the columns (data to be displayed, and column used to correctly order the items) you would simply choose ascending (or descending...whatever the case may be) from the sort by box, but uncheck the box below it. Then you don't have to change column counts or widths. It ileviates those steps and still gets the job done.

Again, thank you so very much for your help. I would be completely lost without the help and knowedge I have gained from this site and the members of it.

 

[theKruser]

My way works for my application, but might not act correctly in other applications. Good point! Thank you for all of your help!