DoCmd.ApplyFilter Question

Question

DoCmd.ApplyFilter Question

simian336 (Programmer)

(OP)

18 Dec 20 21:52

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 (Programmer) · Answer 1 · 2020-12-18 22:01:14

Oops.. I found it.

You can use a query as a filet.

Thanks

Simi

SkipVought (Programmer) · Answer 2 · 2020-12-19 00:48:08

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,
_{Just traded in my OLD subtlety...

for a NUance!}
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

Come Join Us!

Posting Guidelines

DoCmd.ApplyFilter Question