Too Few Parameters error ???

[MLH]

Set rstTemp = .OpenRecordset(dbOpenSnapshot)

Execution of the above line gives me a "Too few parameters"
error. The line is preceeded by another line I thought would
make it work... With qdfTemp

Is something wrong with the syntax? At compile time, I get
no errors.

[MLH]

BTW, am trying to do this without qdfTemp being a
permanent, saved querydef. Is that not possible? Will
be happy to post the bulk of the snippet if need be.

[Bob Quintal]

MLH <CR**@NorthState.netwrote in
news:1c********************************@4ax.com:

BTW, am trying to do this without qdfTemp being a
permanent, saved querydef. Is that not possible? Will
be happy to post the bulk of the snippet if need be.

Sure it's possible. Read the help on openrecordset.

your Set rstTemp = .OpenRecordset(dbOpenSnapshot)
is missing the required first parameter, but you've included the
second, optional, parameter.

try this
strSQL = "SELECT info from HELP where help.key = """ & openrecordset &
""""
Set rstTemp = .OpenRecordset(strSQL)
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[MLH]

Thx, Bob!