Hi
Access2002/2007
WinXPpro Sp2

I find myself stuck with a filter question once again.

I create a filter using AdvancedFilterSort and then save it as a permanent query using
Code:
DoCmd.RunCommand acCmdSaveAsQuery
The new query gets applied to my form successfully and it appears in the Queries object panel. All fine and dandy.

When I open the form and use (via custom button)
Code:
DoCmd.RunCommand acCmdLoadFromQuery
to fire up the applicable filters box (I bet you can guess what I'm going to say??)... the box is empty arrgh! No list of filters!

I'm sure the new filter meets all the criteria to be picked up, indeed it is a very simple query... SQL as below :-

Code:
SELECT *
FROM (SELECT * FROM Addrs AS TBL1 WHERE (TBL1.Deleted=False))  AS Addrs_Dtls_Form
WHERE (((Addrs_Dtls_Form.ID)=756))
It is based on the same table as my form and it is only a SELECT so in theory the load cmd should see it. If i call the query itself it runs properly.

Another morning of surfing reveals lots of other people with the same probem but no real tangible solutions.

Any ideas anyone?