DoCmd.ApplyFilter Question

simian336 · Dec 18, 2020

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 · Dec 18, 2020

Oops.. I found it.

You can use a query as a filet.

Thanks

Simi

SkipVought · Dec 18, 2020

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

DoCmd.ApplyFilter Question

simian336

Programmer

simian336

Programmer

SkipVought

Programmer

Similar threads

Part and Inventory Search

Sponsor