Concatenate Quotation Marks

[millerdav99]

This is probably a dumb one, but I've looked through my books and I cannot find anything on this.

I have a value in a combo box that I want to set as the default value, so I need to put quotation marks around the value. How the heck do I put quotation marks on the end.

If i use the triple quotes it seems to only pick up the string in the middle. here is example of what I have.

strTechName = """ & Me.cbxTechName & """

What ends up getting stored is
" & Me.cbxTechName & "

[ajetrumpet]

there are too many ways to do this. for instance, Allen Browne gives examples using the triplicate """ combinations. the way I use is:

"""" & me.value & """"

[RuralGuy]

This link should help: http://www.mvps.org/access/forms/frm0012.htm

[millerdav99]

Thanks! Both of your replies are basically the same thing. The variable method is a good idea.