Hi Guys,
I'm having a small problem. I am trying to insert the data for the report from a table, instead of having the text already on the report, as i want to allow the user to be able to edit it on another form and thus change the content of the report.
The only problem i'm having is when they reference variables, it is basically putting " & [variable] & " into the textbox and not the actual value of the variable.
You can see this from the following screenshot, notice the above textbox is the old one, which has the variables filled out, where as the bottom textbox is capturing the string from a table and is not displaying the values of the variables, but instead the call.
Any ideas of how i can get around this?
Thanks in advance.
I'm having a small problem. I am trying to insert the data for the report from a table, instead of having the text already on the report, as i want to allow the user to be able to edit it on another form and thus change the content of the report.
The only problem i'm having is when they reference variables, it is basically putting " & [variable] & " into the textbox and not the actual value of the variable.
You can see this from the following screenshot, notice the above textbox is the old one, which has the variables filled out, where as the bottom textbox is capturing the string from a table and is not displaying the values of the variables, but instead the call.
Any ideas of how i can get around this?
Thanks in advance.
