Load From Query via VBA

[Paul Simon]

(I originally posted this message 4-19-04, but it has never shown up.
If it subsequently does, please forgive the double post.)

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 get the
Event Procedure of a command button to open the Advanced Filter/Sort
grid, do Load From Query and then do Apply Filter.

The following code does not work because Load From Query does not
accept parameters:

DoCmd.RunCommand acCmdAdvancedFilterSort
DoCmd.RunCommand acCmdLoadFromQuery, "Discs Acquired"
DoCmd.RunCommand acCmdApplyFilterSort


(I did try this, but it won't work
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?

Many thanks,
Paul Simon