Filter Problem

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

I created a filter, but can't get it to filter with a condition.

I have the following code:
With Me
.Filter = "[Status] = 'Open' AND [Group_Name] = 'Builds'"
.FilterOn = True

I want to change 'Builds' to MDE*. Grab everything that is that has MDE
plus wildcard.
 
Ben said:
I created a filter, but can't get it to filter with a condition.

I have the following code:
With Me
.Filter = "[Status] = 'Open' AND [Group_Name] = 'Builds'"
.FilterOn = True

I want to change 'Builds' to MDE*. Grab everything that is that has MDE
plus wildcard.
Click to expand...


Do you want to use a filter that looks for MDE*
.Filter = "[Status] = 'Open' AND [Group_Name] = 'MDE*'"

or do you want to look for MDE followed by anything
.Filter = "[Status] = 'Open' AND [Group_Name] LIKE 'MDE*'"
 
Back
Top