ApplyFilter - Apply Multiple Filters? 1

[zenenigma]

I have a large table that many people use to view their cases. I currently have a button that when pressed - will prompt the user for the first name of the user who's cases you want to search for. This works fine:

docmd.applyfilter, "emp_first_name = [Enter Investigator First Name]"

The problem is, I also want the user to be able to state if they want to view "open" or "closed" cases:

"[Case Status] = [Case Status (Open or Closed)]"

However, I haven't been able to find a way to include both filters. When I combine them like this:

DoCmd.ApplyFilter , "emp_first_name = [Enter Investigator First Name]" And "[Case Status] = [Case Status (Open or Closed)]"

I get a type mismatch.

Doing one ApplyFilter and then another immediately afterwards results in only the 2nd filter being applied.

Any help would be appreciated.

 

[PHV]

And this ?
DoCmd.ApplyFilter , "emp_first_name = [Enter Investigator First Name] And [Case Status] = [Case Status (Open or Closed)]"


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[zenenigma]

PHV, I should have known the quotes would be the death of me. Thanks so much!