Error With Requery of ADO

[dpatrickcollins]

I am attempting to execute a requery method of an ado recordset created using the Dataenvironment. Recordset queries an Access database. When I attempt to do so, I get the following error:

3219: Operation is not allowed in this context

Anyone know why?

 

[Snowcrash]

You need to post your code as it will likely be something that occurs prior to this statement.

 

[dpatrickcollins]

Thanks snowcrash. My Code is:

rs.Requery

Since the time of posting, I have concluded that a parameterized recordset cannot be requeried. Is this true? For example:

dataenvironment.QueryName
set rs = dataenvironment.rsQueryName <parametervalue>
rs.requery