Error with "dbOpenSnapshot"

[Guest_imported]

HI!

I'm a begginer, and this is my first problem:
I had a Access 97 database, with a Form and a dropdown list which is populated with entries dynamically. Once you click on each opciont it should call up a list of the query result.
But now in 2000 version it doen't work.

The error is on:

Set rsThisRS = dbThisDB.OpenRecordset("", dbOpenSnapshot)

Can you help me?

Thank you very much.

 

[tlbroadbent]

The name parameter in the OpenRecordset method is an empty string ("&quot. Shouldn't that be a table name or query statement?

It appears you are using DAO rather than ADO. You may need to activate the DAO library. Check the answer given in another thread (thread181-4495) about activating the DAO library. Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost