>>If you really must use a filter (yuck), consider setting an application object >or form property in the Valid and basing the filter on that.
>
>The same problem would exist if the end user moved to another form and you had used form properties. That probably wouldn't occur with the application object.
>
>I would reccomend macro substitution in cases like this.
>
>select mytable
>lcvalue = textbox.value
>set filter to field = &lcvalue
>
>It will evaluate immediately and you won't have to worry about scope.
>
>Just my $0.02.
Hi Sir,
Does it really need to be a macro substitution? I have already encountered our friends problem but what i did was just to store on a variable! Would you mind telling me the difference. Thanks!
select mytable
lcvalue = This.Value
Set Filter to field = lcvalue
Inzo