Recordset problem

[Tim]

Hi everyone,

I created a recordset from query. But, it didn't work.
Could anyone can help me?


Dim db As Database
Dim rst As Recordset

Set db = CurrentDb
Set rst = db.OpenRecordset("select ID from qryemp;")

Debug.Print rst.Fields("ID").Value


Thanks in advance.

Tim.

 

[Ken Snell]

What do you mean by "it didn't work"?

 

[Ken Snell]

< g >

--
Ken Snell
<MS ACCESS MVP>

Give up, Ken!!

TC

 

[Tim]

Ken,

The error message is:

Run-time error 3131:
Syntax error in From clause.

Thanks.

Tim.

 

[Ken Snell]

You need to put square brackets around the query name because you have a
hyphen as part of the name:

Set rst = db.OpenRecordset("select ID from [qryemp-ID];")