Query will run as query but not as a recordset

[TimTDP]

I have an unbound form that contains an unbound field
I use this field as criteria for a query.

After I have entered data into the field I can open the query and the data returned is correct.

I have know placed a command button on the form. Part of the code behind the button is to create a recordset based on the query.


When the code runs, I get a run time error 3061 - To few parameters - Expected 1
It I now run the query - the code is still trying to run so it is high lighted in yellow, it does not return any records!

Why is this?

[Nijal]

This is usually caused by asking the query to filter by a field[name] that does not exist in the original query.