Sorry, try putting the macro within quotes:
lcvalue = THISFORM.Spinner1.Value
set filter to somefield = "&lcvalue"
>When I do this I get 'Missing operand'
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.
