Filter Help???

[Access Help]

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.

 

[scubadiver]

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.

 

[Access Help]

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

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

 

[scubadiver]

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

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

 

[Access Help]

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?

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

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

 

[scubadiver]

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

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

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

 

[Access Help]

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?

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?




:

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

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

 

[scubadiver]

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
"[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?

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?




:

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

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