If you use a macro in front of the value, then scope does not matter:
lcvalue = THISFORM.Spinner1.Value
set filter to somefield = &lcvalue
-just a suggestion.
>Hi Larry,
>
>Thanks. This works but only if I make the variable public which is best avoided.
>Any other ideas ?
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.