Pick and Apply a Query to Form

[gray]

Hi

Access 2007, .mdb on local machine

Just toying with the idea of giving my advanced users a button on a form which permits them to create and apply a filter to that form.

Been dabbling with
DoCmd.RunCommand acCmdApplyFilterSort

I created a query and saved it and then called
DoCmd.RunCommand acCmdLoadFromQuery

This pops up with the query 'picker' box but the box is empty. My guess is I've got to somehow associate the new query with the form and then tell the 'picker' window which queries to load?

Anyone ever used this method before and can advise please?

thanks