Try this: Do a debug.Print strSql
Then copy that debug.print result and paste it into an Access Query Sql
window. If the syntax is correct the query will run from the query
window. If you don't get any resultset then you can start modifying
your where clause (removing args) until you do get a resultset. Once
you get a resultset you can start adding the params you removed back in
one at a time until the query either doesn't return a result - or you
have used up all the params. If when you add the params manually in the
query window - it always returns a resultset - then the problem is in
your coding behind the form.
Rich
*** Sent via
Developersdexhttp://www.developersdex.com***
