OpenRecordset help needed

[chris.thompson13]

Any good advice to help solve this problem would be most welcome.

I can not open a recordset based on a query (called qryNoDateSetYet).
The qryNoDateSetYet uses another query within it called qryInputSat.
qryInputSat takes a parameter from a control on an open form.

I get the 3061 run-time error asking for the parameter.

How can I get the recordset to open? - it's driving me mad.

My thanks in advance for any help offered.

Chris.

[Tom van Stiphout]

On 7 Dec 2005 05:21:32 -0800, ch**************@ntlworld.com wrote:

Give it the parameter.
1: dim qd as dao.querydef
2: dim rs as dao.recordset
3: set qd=currentdb.querydefs("myquerydef")
4: qd.Parameters(0) = Forms!MyForm!MyControl
5: set rs=qd.openrecordset(dbOpenSnapshot)

If you want a named parameter, set a breakpoint on line 4 and in the
debug window enter:
?qd.parameters(0).name
Then write:
4: qd.Parameters("myname") = Forms!MyForm!MyControl

-Tom.

Any good advice to help solve this problem would be most welcome.

I can not open a recordset based on a query (called qryNoDateSetYet).
The qryNoDateSetYet uses another query within it called qryInputSat.
qryInputSat takes a parameter from a control on an open form.

I get the 3061 run-time error asking for the parameter.

How can I get the recordset to open? - it's driving me mad.

My thanks in advance for any help offered.

Chris.

[chris.thompson13]

Tom

Just what was needed. Thank you so much for your help and for your
time. It is very much appreciated.

Chris.