I knew the following code wouldn't compile when I wrote it, but I'm showing it here to clarify the question. Namely, can a statement be formed to accomplish what one sees in the code below where I'm trying to utilize the string constants "strDFltxx" where xx is the current value in the variable "intNewTTypeID"? (E.g., Const strDFlt10 as string = "blah blah blah")
Code:
Select Case intNewTTypeID
Case 2, 3, 4, 8, 10, 13
Me.tbNewDescription = strDFlt & intNewTTypeID
Case Else
Me.tbNewDescription = ""
bolFUPending = True
End Select