Returning Multiple values from one combo box

[Daisy509th]

I am using VBA to create the file path located in the textbox. I have everything I need in the path except the last name.

D:\Users\druss\Lauren Concrete\Digtal Libary-DOT Paperwork\Drivers\Alberto\4132018TS.pdf (This is missing last name "Saenz")

D:\Users\druss\Lauren Concrete\Digtal Libary-DOT Paperwork\Drivers\Alberto Saenz\4132018TS.pdf (This is what I need)

Dim strMonth As String, strDay As String, strYear As String, strPresentation As String


strMonth = DatePart("m", Me.Combo197)
strDay = DatePart("d", Me.Combo197)


strYear = DatePart("yyyy", Me.Combo197)


If IsNull(Me.Combo233) Then Exit Sub


MsgBox Me.Combo233
strPresentation = "D:\Users\druss\Lauren Concrete\Digtal Libary-DOT Paperwork\Drivers" & Me.Combo233 & "" & ""
strPresentation = strPresentation & strMonth & strDay & strYear & "TS" & ".pdf"
Me.Text229 = strPresentation
(On a side note can someone teach me how I would add error checking to this code. I know I need to start error checking all my code)


The combo box is showing both values in the drop down but I cant figure out how to grab the second value.

Thanks for the help

[isladogs]

Either use me.combo233 & " " & me.combo233.column(1) assuming last name is the 2nd column

Or add an extra hidden column to your combo the use that in your code
[firstname] & " " & [lastname]

Suggest you actually display that column instead.
First name alone not helpful when there are more than one e.g. Antonio

There are plenty of articles on error handling if you do a google or site search

[CJ_London]

use the column property

& Me.Combo233 & " " & me.combo233.column(2)


note that you do not appear to be using a primary key, so the chances are if you select Antonio Lopez, it will return Antonio Perez because that is the first firstname it will find