DoCmd.ApplyFilter Question

[simian336]

Ok, so I am looking at someone else's code. They have used a filter on a form. But the filter is like

DoCmd.ApplyFilter "NameOfaQuery"

I don't see any documentation that you can use a name of a query as a filter. I assume it is just taking the criteria from the query and applying it to the filter.

Anybody else ever seen this before?

Thanks

Simi

 

[simian336]

Oops.. I found it.

You can use a query as a filet.

Thanks

Simi

 

[SkipVought]

Hi,

Your question is not a VBA question. It is an Access Macro question, best addressed in one of the many Access forums here at Tek-Tips.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein