Open a form and apply a filter to the subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Judy - 16 Dec 2005 17:01 GMT

Hello - I'm trying to open a Master Form with subforms, and filter the
subforms based on the value in a menu form. First I tried using a
Macro and opening the form with a where condition applied to the
subform. Then I tried to apply a filter to the subform. When I apply
the filter the subform opens by itself, but will not open correctly in
the main form. Any suggestions about how to accomlish this would be
greatly appreciated.

Judy

Reply to this Message

Marshall Barton - 16 Dec 2005 19:56 GMT

>Hello - I'm trying to open a Master Form with subforms, and filter the
>subforms based on the value in a menu form. First I tried using a
[quoted text clipped - 3 lines]
>the main form. Any suggestions about how to accomlish this would be
>greatly appreciated.

The OpenForm method does not apply to subforms so the
WhereCondition argument is out of the question.
Unfortunately, setting the Filter property in a
mainform/subform arrangement has a major bug in that setting
one erases the other.

The old reliable way to do what you want is to create and
(re)assign the form's and/or subform's RecordSource SQL
statement. When first opening the main form, this should be
done in the (sub)form's Open event.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Judy - 17 Dec 2005 06:41 GMT

Thanks Marsh - I will give that a try. Judy

Reply to this Message