I have a database with around 40 queries. I have a module which runs all the queries using the following (abbreviated) code:
On Error GoTo RunQueries_Err
DoCmd.OpenQuery "Query_1", acViewNormal, acReadOnly
DoCmd.Close acQuery, "Query_1"
DoCmd.OpenQuery "Query_2", acViewNormal, acReadOnly
DoCmd.Close acQuery, "Query_2"
It works fine, but what I want to do now is copy this code and add a condition that Field_3 (which appears in all queries) should be set to "n". Suggestions most welcome.