Filter Help???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Access Help - 20 Jul 2007 12:26 GMT

Hi all,
Can anyone help, please. I am trying to filter child (mrc child form) forms
from a parent form.
Using a combo (FilterMnau) in the header of the Parent (form Index) to
filter the data in the child form. But the child form doens't change. The
macro condition below:
[Forms]![index]![FilterManu] Like [Forms]![index]![mrc].[Form]![manufacturer]

Can somone please help.

Reply to this Message

scubadiver - 20 Jul 2007 13:02 GMT

Are the fields in the subform based on a select query? Along my line of
thinking it should be. In the design grid of the query insert

[Forms]![index]![FilterMenu]

into the appropriate criteria assuming this refers to the combo box in the
parent form.

In the after update event of the combo box insert:

[forms]![index]![mrc].requery

I think that should work.

> Hi all,
> Can anyone help, please. I am trying to filter child (mrc child form) forms
[quoted text clipped - 5 lines]
>
> Can somone please help.

Reply to this Message

Access Help - 20 Jul 2007 13:28 GMT

Thanks but I was using a Macro. I used the code given but I get the error
"Microsoft Access can't find the macro 'forms!index!mrc'
Any ideas why?
Thanks

> Are the fields in the subform based on a select query? Along my line of
> thinking it should be. In the design grid of the query insert
[quoted text clipped - 19 lines]
> >
> > Can somone please help.

Reply to this Message

scubadiver - 20 Jul 2007 13:48 GMT

Then you must be referencing a macro called 'forms!index!mrc' that doesn't
exist?

> Thanks but I was using a Macro. I used the code given but I get the error
> "Microsoft Access can't find the macro 'forms!index!mrc'
[quoted text clipped - 24 lines]
> > >
> > > Can somone please help.

Reply to this Message

Access Help - 20 Jul 2007 14:00 GMT

no more error, but the child form (in datasheet view) doens't change. It
tries too but doens't actually filter. Any Ideas?
thanks

> Then you must be referencing a macro called 'forms!index!mrc' that doesn't
> exist?
[quoted text clipped - 27 lines]
> > > >
> > > > Can somone please help.

Reply to this Message

scubadiver - 20 Jul 2007 14:08 GMT

Would it be too much trouble to write out the code in the macro?

> no more error, but the child form (in datasheet view) doens't change. It
> tries too but doens't actually filter. Any Ideas?
[quoted text clipped - 31 lines]
> > > > >
> > > > > Can somone please help.

Reply to this Message

Access Help - 20 Jul 2007 14:34 GMT

the code in the macro are as follows;
in the where condition
"[Forms]![index]![FilterManu]=[Forms]![index]![mrc].[Form]![manufacturer]"
and in the condition field of the macro
"[Forms]![index]![FilterManu]"

> Would it be too much trouble to write out the code in the macro?
>
[quoted text clipped - 33 lines]
> > > > > >
> > > > > > Can somone please help.

Reply to this Message

scubadiver - 20 Jul 2007 14:40 GMT

My thought is that you are basing the subform on the form so shouldn't it be:

"Forms]![index]![mrc].[Form]![manufacturer]=[Forms]![index]![FilterManu]"

And shouldn't it be "menu" instead of "manu" or is that the correct spelling?

> the code in the macro are as follows;
> in the where condition
[quoted text clipped - 39 lines]
> > > > > > >
> > > > > > > Can somone please help.

Reply to this Message