Recordset and Too Few Parameters

[Jackson via AccessMonster.com]

Hi,

A couple of times I've tried to open a query as a Recordset in VBA which has
a date (set to an unbound text box on a form) as query criteria and I always
run into problems. It comes up saying Too Few Parameters, one required. Can
anyone help me explicitly tell VBA that the form text box is where it should
be looking for the parameter?

Thanks.

 

[dymondjack]

It depends on how you execute the statement. Certain methods won't evaluate
the expression pointing to the textbox.

Another method would be to store the value from the textbox into a variable,
and then insert the variable into the SQL.

If you need further information, please post your sql statement and the
method of execution.

--
Jack Leach
www.tristatemachine.com

- "Success is the ability to go from one failure to another with no loss of
enthusiasm." - Sir Winston Churchill

 

[dymondjack]

http://www.mvps.org/access/forms/frm0031.htm

You can try this... it was written for forms/subforms, but the 'anywhere
else' part works, well, anywhere else.


--
Jack Leach
www.tristatemachine.com

- "Success is the ability to go from one failure to another with no loss of
enthusiasm." - Sir Winston Churchill