I have a select query with parameters from a form and subform. If I just run the query and type in some values, the query returns the correct number of rows. If I run the query in the subform delete code using docmd.openquery I can see the parameter values in a message box so I know I've got the correct parameter values, but when running the query from the code, no records are returned. I've replicated this in a test environment as well, and when I remove the parameters, the query runs returning all records.

Am I doing something wrong or is this due to running a query with parameters in the delete event of the subform?

Thanks!
Kim