Applying a filter to a subform

[Guest]

I'm trying to apply a filter to a subform. The filter is strCrit and the
form is frmContactSearchResults & the subform is subContactSearch.

The command that I currently have is:
Forms!frmContactSearchResults.subContactsSearch.Form.Filter = StCrit

However, this is not working. Any suggestions?

Thanks.

 

[Rick Brandt]

I'm trying to apply a filter to a subform. The filter is strCrit and
the form is frmContactSearchResults & the subform is subContactSearch.

The command that I currently have is:
Forms!frmContactSearchResults.subContactsSearch.Form.Filter = StCrit

However, this is not working. Any suggestions?

Thanks.

What does "..not working" mean? Do you get no response? An error? An incorrect
response?

 

[Guest]

It doesn't apply the filter at all.

What does "..not working" mean? Do you get no response? An error? An incorrect
response?

 

[Van T. Dinh]

You also need to set the FilterOn Property to True

 

[Guest]

Doing my happy dance.

It works! It works! It works!

Thanks to both of you!

 

[Guest]

I'd like to do a happy dance too Ed!!! Hoping you can Pay It Forward

What you did sounds exactly like what I need...However I'm obviously more of
a novice. Exactly where did you put this filter criteria? Is this in visual
basic and how do I do so? Is strcrit a saved filter query?

I want my subform to filter by DeptID....such as [DEPTID]="FR". Have a
filter query set to do that and works on subform alone but not in main form.
Help?

Thanks in advance.