[AccessD] Question - subform filter

Jim Hewson jm.hwsn at gmail.com
Wed Aug 15 10:40:25 CDT 2012


I didn't turn off the filter, set it and then turn it back on ... during
the course of creating the subforms a few had filters turned on and the
filter was set.  Those worked.  The subforms that had the filter turned off
and the filter was empty did not work. Once I turned on the filters of all
the subforms and set the filters.... it works!
What I hear you say, is the way to get around this is to save the forms and
subforms with blank filter properties.  Through code, turn off the filter,
set it, then turn it back on.

Thanks, I'll try that.

Jim
On Wed, Aug 15, 2012 at 10:14 AM, Charlotte Foust <charlotte.foust at gmail.com
> wrote:

> I'm not sure I understand.  You can, in fact leave a filter blank in the
> property sheet of the form, but in code you have to turn the filter off,
> set it to the new string, and then turn it back on.  I always save my forms
> and subforms with blank filter properties as a matter of course.
>
> Charlotte
>
> On Wed, Aug 15, 2012 at 7:43 AM, Jim Hewson <jm.hwsn at gmail.com> wrote:
>
> > Sometimes, it just doesn't make sense - to me anyway.
> >
> > I have two databases, virtually identical. One was working, the other was
> > producing strange results.
> > I have a form with a subform.  The subform dynamically changes to either
> > have multiple subforms or a single subform.
> > When the subform changes to have multiple subforms, in one file it would
> > work - the other would not.  The contents of the subforms would not
> change.
> > After much work... comparing code, properties, data (data is identical in
> > both), importing and exporting objects. I finally found the problem.
> >
> > Apparently, if I want to ensure the subforms change dynamically, with
> > different records, the Filter must be set and cannot be left blank.  Even
> > though the filter changes for each record the data of the subform does
> not
> > change.
> >
> > Why is that?
> >
> > Thanks
> > Jim
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> >
> >
> > Website: http://www.databaseadvisors.com
> >
> >
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list