Filter Problem

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

 

[Marshall Barton]

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.

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*'"