Invalid argument??

[Eric]

I'm getting an invalid argument message (run-time error
3001) on the following line:

Set rs = db.OpenRecordset("SELECT * FROM
tblLinesRequested WHERE fldRequestID = " & Forms!
frmAllRequestsTemporaryLines!RequestID, dbSeeChanges)

p.s. I'm using a linked sql table with an identity column.

Thanks.

 

[PC Datasheet]

There is no "dbSeeChanges" constant for the OpenRecordset method.

 

[Brendan Reynolds]

There is, but it needs to be passed as the third, 'Options' argument, not as
the second, 'Type' argument ...

Public Sub TestDbSeeChanges()

Dim db As DAO.Database
Dim rst As DAO.Recordset

Set db = CurrentDb
Set rst = db.OpenRecordset("SELECT * FROM dbo_authors", , dbSeeChanges)
Debug.Print rst.Fields(0)
rst.Close


End Sub

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Eric]

Thanks very much Brendan, you were right, it works now!

-----Original Message-----
There is, but it needs to be passed as the

third, 'Options' argument, not as