'Select in Field' based on a variable value

[#1]

Hi,

I am trying to use the 'Select in Field' action on a button to select a value that is held in a variable, but it does not work.

I have a field called NAME and a variable called v_NAME. v_NAME already holds a valid value of a NAME.

So the Field in the Action is NAME, and the Search String is =v_NAME, but that fails. When I change the Search String to have the literal value that is held in the variable, it works fine.

Any ideas or suggestions?

many thanks,

[swuehl · Accepted solution]

Works for me. Could you post a small sample app that demonstrates your issue?

[#3]

Thank you, that comment helped me work out my issue.

My variable was populated as a result of a GetCurrentSelections statement with a subfield in it. I had not spotted the extra space on the left, so my string was not a match. A simple ltrim solved it for me.

Alan