Expression or List box

[Jester1147]

kind of have two problems here.

One:
Creating an expression to compine fields into one

Expr1: [Rank] & ' ' & [First Name] & ' ' & [Last Name] - Im sure this is pretty self explanitory. My issue is that [Rank] is from a combo box so it will only display the "RankID" which is the autonumber field and not the field with the Rank (because obviously rank order is not alphabetical).

4 John Snuffy when it should be SrA John Snuffy

Two:
"hiding the combo box arrow"

Actually has a the exact same problem, it will show the (for example) "RankID" and not the "Rank" field. Im using both of these on seperate forms.

Thanks

 

[ghudson]

Each field in a combo box is a column. Column #1 is defiend as .column(0)

This will reference column #2 in your combo box...

YourColumnNameHere.Column(1)

 

[Jester1147]

I apologize for my ignorance, but that code will go... where?

Also will that fix the Expr issue as well?

 

[Jester1147]

disregard the first part... i have the text box resolved. But not the Expression. It still shows the RankID in the expression.