I am trying to learn to user Parameter queries. My simple test query is:
PARAMETER [Account] CHAR ;
SELECT * FROM tblAccount WHERE [Account] = "123456"
In my VBA code, I have determined that I want to run this query with [Account] = "654321"
How to I put this in code? Does the query have to be stored in QueryDefs?
Thanks,
Gerry Goldberg
PARAMETER [Account] CHAR ;
SELECT * FROM tblAccount WHERE [Account] = "123456"
In my VBA code, I have determined that I want to run this query with [Account] = "654321"
How to I put this in code? Does the query have to be stored in QueryDefs?
Thanks,
Gerry Goldberg