[AccessD] Datasheet Filters

[Ryan W]

Rocky,
 The datasheet form should use .FilterOn (True or False) to tell you
whether it's filtered, and the .Filter property to show what's filtered:


?Forms!Form1!t.form.filteron
True
?forms!form1!t.form.filter
((([Table1 subform].[Field1]="foo_zip") AND ([Table1 subform].[ID]=1))) AND
([Table1 subform].[Color]="vbBlack")

On Sun, Mar 12, 2023 at 6:41 PM Rocky Smolin <rockysmolin2 at gmail.com> wrote:

> Dear List(s):
>
> I have a subform in datasheet format on a main form.  Several of the fields
> on the subform are currency fields.
>
> The client wants sums and averages on several of those fields. I explained
> that you can't do that with a datasheet but that in the footer of the
> parent form I could give him all that data but the sum and average won't
> line up under its column.  No problem for him.  He's happy with the data on
> the footer.
>
> Since they will be using the filters on the datasheet fields to
> restrict the data to just that they're interested in, that, obviously, will
> change the values of the sum and averages as they apply different filters.
>
> What I need then is a way to see what the filters are, and generate a sql
> statement with those filters as the source of the sums and averages.
>
> Q: Is there a way to poll the filters on those fields? I don't know of one.
> But I'll bet there is one.
>
> MTIA
>
> Rocky
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>