VBA in variables

[smikkelsen]

I have a text field allowing users to enter custom notes that can be selected from a combo box on a different form (allowing them to use the note over and over without typing it each time).



I want the user to be able to access some field contents in their notes.

For example a user might type this note:

Sent Bob an email to follow up on progress.

I would like them to be able to write a note like this:

Sent [customer] an email to follow up on progress.

so that the [customer] field will be entered.

Here is the code I have:

 
Dim temp As String
temp = DLookup("[Note]", "Local_CustomNotes", "[Title] = '" & [cmb_CustomNote].Column(1) & "'")
MsgBox temp
[Text0] = temp

the dlookup will grab the custom note that the user has saved and enter it into the text0 field.

I thought if the user typed something like this:
"Sent " & [customer] & " an email to follow up on progress."
in the custom note area, it could do what I wanted. But instead it looks at all of it as literal string.

Is there an easy way to accomplish this?

Thanks!

[pbaldy]

One way that comes to mind (I'm assuming the customer is on the form):

temp = Replace(temp, "[Customer]", Me.TextboxWithName)

replacing TextboxWithName with the name of the textbox containing the name you want to use.

[smikkelsen]

That is a great idea. There are probably 50 fields that they could possibly use in their notes. Is there a more dynamic way of doing it? If not I can just code a replace for every possibility.

[weekend00]

You should think a way to put customer name in the notes at the time user setup the notes.
you can not rely on the user type in the notes following the program syntax. e.g. if you want "Sent " & [customer] & " an email to follow up on progress."
but the user miss some " or other thing, your program will run into an error.