[AccessD] Question - subform filter

Charlotte Foust charlotte.foust at gmail.com
Wed Aug 15 10:14:02 CDT 2012


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
>
>
>


More information about the AccessD mailing list