Access "Load from Query..." Dialog Box

Question

On the Access Home Ribbon in the "Sort & Filter" section, in the Advanced dropdown list, there is a normally disabled option called "Load from Query...".  Under what circumstances is that option enabled so I can see what the dialog box looks like?

Answer 1

With a table open in datasheet view for instance, you firstly need to select 'Filter by Form'.  The 'Load from Query' option will then become available, and when selected will open a dialogue which lists saved queries which can restrict the rows returned from the table.  Selecting a query will load the relevant values into the datasheet in 'Filter by Form' view.  Clicking on the Toggle Filter option in the 'Sort & Filter' area of the ribbon will then apply the filter, and the datasheet will return the rows which satisfy the filter criteria.

The same can be done with a bound form if the 'Save as Query' option has previously been used when a form is in 'Filter by Form' view.  In this case the saved query will alias a subquery as the form name.