Text box from Drop Down not working

[WillM]

I have a textbox that has 3 columns in it (Rank, First Name, Last Name)...when the user selects the appropriate choice, it just shows the Rank.

Ex: Lt. John Smith --> just shows Lt.

To get around this I made an unbound text box and have it set to show all three choices when the selection is made in the drop down box. Unfortunately, it isn't working right. This is the code I am using for the text box:

=[OPRID].[column](1) & [OPRID].[column](2) & [OPRID].[column](3)

Is there anything that looks wrong with this code?

What it ends up showing in the text box is: JohnSmith (no rank, no space between the names).

 

[pbaldy]

The column property is zero based, so start with that. You can concatenate spaces into your string:

... & " " & ...

 

[WillM]

Thank you, that fixed it just fine. I cannot get the Rank to show up...my Table is setup like this:
RankID Rank FirstName LastName

Can't figure out why it wont show the Rank in the textbox.

 

[pbaldy]

What is your formula now? Did you start with 0?