Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jmrSudbury
-
Interchangeable form control criteria
You can dynamically change the SQL of a query. 'Open the query as a QueryDef dim qdf as querydef set qdf = currentdb.QueryDefs("YourQueryName") qdf.sql = left(qdf.sql, instr(qdf.sql, _ " WHERE ")-1 & " WHERE " & txtYourNewCriteria qdf.close Just make sure that...- jmrSudbury
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
