Filter Help Needed

[Guest]

I am creating a simple Macro to do filters. Here is what I put in the macro.
[Forms]![PostMigration]![Filter]="Boston Division"

Where Condition: [PostMigration]![Division_Name]="Boston Division"

When I run the Macro from the Form, I get a prompt instead of it Filtering.
I have a Form, then a Subform. The filter is for the main form. What is the
problem?

 

[Steve Schapel]

Bronen,

My apologies, I can't understand. What are the Actions you have in your
macro? Where did you put this:
[Forms]![PostMigration]![Filter]="Boston Division"??
What is the Where Condition an argument of which macor action?
Thanks.

 

[Guest]

Macro Name: DivisionFilter

Condition: [Forms]![PostMigration]![DivisionFilter]="Boston Division"

Action: ApplyFilter

Where Condition: [PostMigration]![Division_Name]="Boston Division"

I have an Unbound combo-box on my form. It has everything correctly
identified, and whatnot. When I click on a site, i.e. Boston Division, I get
a prompt asking me to type something in. Instead of it actually filtering to
the entry for Boston DIvision. What am I doing wrong that it's asking me to
type something in. It shouldn't ask anything.

Thanks

Bronen,

My apologies, I can't understand. What are the Actions you have in your
macro? Where did you put this:
[Forms]![PostMigration]![Filter]="Boston Division"??
What is the Where Condition an argument of which macor action?
Thanks.

--
Steve Schapel, Microsoft Access MVP

I am creating a simple Macro to do filters. Here is what I put in the macro.
[Forms]![PostMigration]![Filter]="Boston Division"

Where Condition: [PostMigration]![Division_Name]="Boston Division"

When I run the Macro from the Form, I get a prompt instead of it Filtering.
I have a Form, then a Subform. The filter is for the main form. What is the
problem?

 

[Steve Schapel]

Bronen,

Do you get a 'Enter Parameter Value' dialog popping up? Is that what
you mean by "it's asking me to type something in"? If so, what is the
parameter it is asking for? (This should be shown on the dialog form,
above the textbox for your entry).

Do you mean that this macro is running on the PostMigration form? If
so, the Forms! qualifier is not needed. Try it like this...
Condition: [DivisionFilter]="Boston Division"

In this expression...
Where Condition: [PostMigration]![Division_Name]="Boston Division"
.... what is "[PostMigration]"? I would assume that [Division_Name] is
the name of a field in the table/query that the form is based on. Is
that correct? If so, try it just like this...
Where Condition: [Division_Name]="Boston Division"