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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query Criteria Set up In Module
- Thread starter samn265
- Start date
tomschafer
Technical User
Its easier to just change the entire sql of the query in a module. This should get you going...
Dim qryQuery As QueryDef
Dim qrySQL As String
Set qryQuery = CurrentDb.QueryDefs("QueryName"
qrySQL = "select name from msysobjects"
qryQuery.SQL = qrySQL
Dim qryQuery As QueryDef
Dim qrySQL As String
Set qryQuery = CurrentDb.QueryDefs("QueryName"
qrySQL = "select name from msysobjects"
qryQuery.SQL = qrySQL
- Thread starter
- #3
- Status
Similar threads
- Question
- Locked
- Question