J
JimS
I have a form with a 7-tabbed control, each tab contains a subform linked to
the main form Parent/Child. The subforms do little but display a datasheet of
related data.
I can search the main form for a project and that works fine. (This form
takes 20+ seconds to requery...)
When I go a tab, click in a cell of the contained datasheet and try to
filter it, the following occurs:
..If I use the lightning bolt (filter by example), it works as expected
and filters the subform just fine. When I deselect the filter for that
subform, it requeries the entire main form and goes back to the beginning of
the query...not convenient.
..If I hit the filter by form button, it filters the subform just fine,
but requeries and reverts to the first project in the list. When I go back to
the main form and search it, the results are correct, filter on the subform
and all.
What can I do to stop the main form from requerying at annoying times and
make it work smoothly without re-searching (as in example 2), or
filterbyexample (as in example 1)?
I can provide a screenshot of the form if it's helpful.
Jim
the main form Parent/Child. The subforms do little but display a datasheet of
related data.
I can search the main form for a project and that works fine. (This form
takes 20+ seconds to requery...)
When I go a tab, click in a cell of the contained datasheet and try to
filter it, the following occurs:
..If I use the lightning bolt (filter by example), it works as expected
and filters the subform just fine. When I deselect the filter for that
subform, it requeries the entire main form and goes back to the beginning of
the query...not convenient.
..If I hit the filter by form button, it filters the subform just fine,
but requeries and reverts to the first project in the list. When I go back to
the main form and search it, the results are correct, filter on the subform
and all.
What can I do to stop the main form from requerying at annoying times and
make it work smoothly without re-searching (as in example 2), or
filterbyexample (as in example 1)?
I can provide a screenshot of the form if it's helpful.
Jim