Replace function using Form Control Value

[Sinfathisar]

I am trying to use the string value from a form control as the criteria for a query. I first need to replace the "," in the string with "AND".

So far I have a module using the Replace function, but it doesn't seem to be working. I am not sure I can reference the string inside the form control directly....if I can, I might have a syntax error.

Here is my code so far:

 Dim result As String
 result = Replace("Forms!Processing!Dataset_Acreage_Query", ",", "AND")

I am not experienced and having trouble finding the search terms to answer this question.

Thanks for any help!

 

[pbaldy]

You don't want the form reference in quotes.