Why can't I use Dim dbs as database

[Swarland]

I am trying to follow using the making of a recordset from a query, but I need to set up the database variable "As database"; however, my system doesn't have Database in the dropdown box.

I am using Access 2007 with XP.

regards

Roger

[RuralGuy]

Have you included the DAO library in your references?

[Swarland]

Not that I am aware of: How do I do that please?

[RuralGuy]

This link should get you there: http://www.btabdevelopment.com/ts/missref

[Swarland]

Once again RuralGuy, many thanks for your help.

regards

Roger

[RuralGuy]

Glad I could help.