Filter Help Needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

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





Steve Schapel said:
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?
Click to expand...
Click to expand...
 
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"
 
Back
Top