I have a script I use on three different buttons - economy of scripting on my part which seems to work. It basically extracts information from a table. On two of the buttons I use an optional parameter which changes direction the script as in
1) Country = 'UK'
2) Active = 'Yes'
Both of these parameters work perfectly well. I want to add a parameter to another button which effectively says 'filter on whatever county shows in the county search box'. (I have a drop-down box with all counties listed, I want the result of the drop down to be the parameter result.)
I have tried
County = CountySearch
County = 'CountySearch'
County = "CountySearch"
with no effect. Can anyone advise how I can get the parameter to filter based on whatever is found in the CountySearch box?