Insert Field Value into MsgBox Text

[jtm013]

Hello,

I've gotten myself in a pickle.

I have a message box which needs to include the User name when it pops up.
Subsequently, I have my code as MsgBox "Text here" & Me.Fieldname.Value & "More Text Here".

Works great...but the field in question is a combo box which is tied to a table including User #, First Name, Last Name.
Now I have the combo box set up to display just the first/last name by directing
Row Source to the tbl_userinfo,
Bound Column = 1
Column Count = 1


etc.
I have no idea how to get my msgbox to display "blah blah John Smith blah blah" instead of "blah blah 123 blah blah"



Any and all help is appreciated.

[pbaldy]

It would be

Me.ComboName.Column(x)

where x was the zero-based column number you wanted. Based on your comment above, the column count property is wrong though.

[June7]

Reference combobox columns by index. Index begins with zero.

Like:

"Text here " & Me.combobox.Column(1) & " " & Me.combobox.Column(2) & " more text here"

Advise not to use spaces and special characters/punctuation (underscore is exception) in naming convention.

[jtm013]

It would be

Me.ComboName.Column(x)

where x was the zero-based column number you wanted. Based on your comment above, the column count property is wrong though.

Thanks that did it! Yeah, I was typing fast don't worry the column count is actually set up properly.

Reference combobox columns by index. Index begins with zero.

Like:

"Text here " & Me.combobox.Column(1) & " " & Me.combobox.Column(2) & " more text here"

Advise not to use spaces and special characters/punctuation (underscore is exception) in naming convention.

Don't worry June 7 no special characters or spaces in the field naming conventions I was just describing the data.

Thanks to both of you for the quick reply! SOLVED.

[pbaldy]

Happy to hellp!