How to modify a query’s WHERE clause with openQuery
I would like to be able to open a query from my form & have query results reflect what it is I entered on the form controls. However, looking at the openQuery method of the doCmd object, I don’t see anyplace where I might change the query’s WHERE clause based upon what I’ve entered in my form. What are my options? Please advise.
I would like to be able to open a query from my form & have query results reflect what it is I entered on the form controls. However, looking at the openQuery method of the doCmd object, I don’t see anyplace where I might change the query’s WHERE clause based upon what I’ve entered in my form. What are my options? Please advise.
