Eh!
I thought you were explicitly setting up a filter condition with "set filter to...".
Looks like you're probably better off going the cursor route (as I think Mike suggested).
Suerte,
Alex
>>Epale pana,
>Ejele!!!
>
>>
>>You could clear the filter in your form's init event or perhaps right before the form sets the new filter.
>
>I create the filter from within a button's click event, something like this:
>
>myfilter=".t."
>if thisform.check1.value=1
> myfilter=myfilter+" and myfileld>0"
>endif
>
>if thisform.check1.value=1
> myfilter=myfilter+" and !empty(myotherfileld)"
>endif
>
>if !empty(thisform.text1.value)
> myfilter=myfilter+" and myanotherfield="+thisform.text1.value
>endif
>
>..etc
>
>myfilter="report form myreport for "+myfilter+" preview"
>&myfilter
Low-carb diet not working? Try the Low-food diet instead!