recordset as argument

  • Thread starter Thread starter JC
  • Start date Start date
J

JC

dim rst as recordset
set rst = currentdb.openrecordset("qMyQuery",dbopendynaset)

I pass rst as an argument to one of my procedures. When
it gets to the called procedure the records are NOT in the
order as defined by qMyQuery.
If I do a requery, all the records are back in the correct
order.
Is this the way it should work? Shouldn't I be able to
expect the recordset based on a particular query to be
ordered correctly without having to requery it?
Thanks.
- jc -
 
Hmm, i think at me this works fine, try to decare a dbs variable as
database, set it to currentdb and use it instead of currentdb when you open
recordset
 
Back
Top