subform filter control

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill H. - 02 Nov 2006 06:12 GMT

For the after update event of a combo box (named "classcombo") on the main
form Frm_Main, how do I set the filter control on the subform,
Frm_Main_subform.filter?

I'd like to say Forms!Frm_Main_subform.filter = "PriKey = " &
classcombo.column(0)

Thanks

Signature

Bill

Reply to this Message

Damian S - 02 Nov 2006 06:41 GMT

Hi Bill...

Close... you missed a bit in the middle of it. The syntax to set a filter
on a subform is as follows:

forms!MAINFORMNAME.NAMEOFSUBFORMCONTROL.form.filter = FILTER
forms!MAINFORMNAME.NAMEOFSUBFORMCONTROL.form.filteron = true

Of course, if you have your main form and subform set up correctly, there
should be a link between the two forms that will enforce this filtering for
you automatically.

Hope that helps.

Damian.

> For the after update event of a combo box (named "classcombo") on the main
> form Frm_Main, how do I set the filter control on the subform,
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Bill H. - 02 Nov 2006 07:55 GMT

I'll give it a try.

Normally, yes, subform is enforced via link to main form, but in this case
I'm using UNION queries in the subform, and I can't seem to get the link
working the way I expect it to. :-)

Yeah! It works. Thanks!

> Hi Bill...
>
[quoted text clipped - 20 lines]
> >
> > Thanks

Reply to this Message