Default Value using a public variable...why isn't this working

[jwill]

I'm trying to set the defaultvalue property using a variable. When I check the variable in the immediate window it gives me the correct value. The data type of the variable is a string, so I'm not sure why this isn't working. I'm getting #name? in the text box. Any ideas?

Me.entering_assoc_ID_txt.DefaultValue = var_assoc_id

[jwill]

Never mind I figured it out its:

Me.entering_assoc_ID_txt.DefaultValue = "'" & var_assoc_id & "'"

....whatever Microsoft, lol