Can I open a Select Query as a Record Set?

  • Thread starter Thread starter Bill Johnson
  • Start date Start date
B

Bill Johnson

Is this supposed to work? I'm trying to perform an
operation in VB code based on the results of a Select Query

rst1.Open "SELECT * FROM qryFSAgingDetail", cnn,
adOpenForwardOnly, adLockReadOnly

The select query includes fields from three tables.

I'm getting an error :

"No value given for one or more parameters"
"Error Number" -2147217904

I'm thinking my use of a query is the most likely reason.
 
No reason it shouldn't work. Does qryFSAgingDetail work by itself? Does it
require parameters?
 
That might be it,

The Select Query uses a field from a form, but even so,
the form is open and available for the query to get it's
value when I'm running the code....
 
I removed where my query was asking for a value from a
form and that seemed to correct THAT error. Thank you!

Moving forward to the next. :)
 
Back
Top