DOES ANYONE KNOW THE ANSWER TO THIS QUESTION. I GOT THIS QUESTION
FROM ANOTHER THREAD, BUT THERE WAS NO ANSWER. I HAVE THE EXACT SAME
PROBLEM. ANY HELP WOULD BE GREATLY APPRECIATED!

I created a filter in the Advanced Filter/Sort grid, then did Save as



Query, naming the query "Discs Acquired". I'm now trying to write code

that will open the Advanced Filter/Sort grid, do Load From Query

(choosing the "Discs Acquired" query), and then do Apply Filter.

The following code does not work because acCmdLoadFromQuery apparently

does not accept parameters (as best as I can tell):

DoCmd.RunCommand acCmdAdvancedFilterSort

DoCmd.RunCommand acCmdLoadFromQuery, "Discs Acquired"

DoCmd.RunCommand acCmdApplyFilterSort

(I also tried the following line, but it failed as well

DoCmd.ApplyFilter "Discs Acquired", ""

If I take the errant "Discs Acquired" parameter out of the

acCmdLoadFromQuery command, the program runs fine, except that a dialog

box entitled Applicable Filter comes up from which the user must pick

"Discs Acquired" from the list.

Is there any way that I can get Load From Query to automatically load

"Discs Acquired" to avoid the extra step of having to choose it from

the list in the Applicable Filter dialog box?