NowWhat!!!Simple SELECT wont worK!

[mud2]

In Database, where some Forms use a DoCmd.RunSql DO WORK, This doesn't
Dim ThisSql As String
ThisSql = "Select Keytable.Key FROM KeyTable;"
DoCmd.RunSql ThisSql

Instead, an error message: "RunSql requires an SQL Statement"
This same Sql in a query does work!

I had more success when I was a teenager on dates!

[geekgirlau]

RunSQL is only used for an action query (delete, update or append), while SELECT returns records without actively doing anything. Your SELECT statement will work if you use this to populate a recordset.