easy question, please help

[ice-9]

How do i call a existing query and use its fields.

i have the following

Dim cnn As ADODB.Connection
Dim rs As New ADODB.Recordset
Set cnn = CurrentProject.Connection
rs.Open "CountFollowups", cnn

CountFollowups is my query.
But i keep getting the error 3001. Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another

 

[reclusivemonkey]

i have the following

Dim cnn As ADODB.Connection
Dim rs As New ADODB.Recordset
Set cnn = CurrentProject.Connection
rs.Open "CountFollowups", cnn

Try

rs.Open "SELECT * FROM CountFollowups", cnn

I believe you need a valid SQL statement for this to work