How do I make visual basic put a criteria in a query?

A

Allen Browne

Assign it to the SQL property of a query.

For example, if you have a query named Query2:
strSql = "SELECT * FROM Table1;"
Currentdb.QueryDefs("Query2").SQL = strSql

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

"Powering Queries with VB" <Powering Queries with
[email protected]> asked the question in the subject in message
news:[email protected]...
 
Top