Applying a filter to a subform

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

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.
 
Ed said:
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.
Click to expand...

What does "..not working" mean? Do you get no response? An error? An incorrect
response?
 
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.
 
Back
Top