SQL statement in module returns the same record instead of different

[Minden32]

I'm using adodb.recordset, Access2000, MSSQL linked tables along with required parameters to try and return a set of records. However I keep getting multiple instances of the same record (first one) instead of different ones. I've tested the query in Access query and it works OK and also using TSQL in SQL and that works fine, it only seems to happen when calling the select statement from the module.
Any ideas/help gratefully received.

 

[cmmrfrds]

It would help if you could show the code you are trying to execute. Also, why are you linking sql server tables instead on doing a connection to the database in an Access Project?

 

[Minden32]

Thanks!
Will have a look at Access Projects and let you know.

I've only recently moved to 2000 and therefore didn't know Projects existed - Doh!