>Hi All,
>
>I have a cbizobjmaintenance form with the first page containing a list of all the people in the database.
>
>I want to be able to show everyone on the database OR allow the user to select from a list combobox the category of entries to show on the list. ??? Is there is a way to programatically change the view filter or have no view filter at all??? or is there some other way to bypass the filter in the view???
>
>The master list of selection categories is on another table that is loaded into an array in memory. But the list has nothing to say 'select all'.
>
>Any suggestions
>
>Regards,
>
>Bill
If your view has a condition that is something like WHERE Field = ?Thisform.somevalue, then you could just add a form property that's called UseFilter. Change the WHERE clause of the view to WHERE !Thisform.UseFilter or (Field = ?Thisform.somevalue).