Parameter Query that does not prompt

[bnhcomputing]

I have created a simple parameter query. What I would like to do is:

SELECT * FROM QUERY1(param1=2008) and get back the data for year
2008.
SELECT * FROM QUERY1(param1=2007) and get back the data for year
2007.

The problem is, it ASKS for the year, is there a way to actually pass
in the year whithout making a form?

Thanks in advance

 

[Allen Browne]

The alternative to creating a form is to dynamically generate the SQL string
instead of asking for a parameter, e.g.:
iYear = 2008
strSql = "SELECT Query1.* FROM Query1 WHERE TheYear = " & iYear