recently Christian (Bitsqueezer) was helping me out with a question and he shared this portion with me below
But be careful: A parameterized query assigned through the Recordset property sometimes can be a little bit strange, depending on the query, the fields in the form, the functions you implemented. It needs more tests than a normal bound query.
so i also did some reading up and came across this on FMS's website (http://blog.fmsinc.com/microsoft-access-inconsistent-compile-error-for-a-field-reference-in-a-form/
really good stuff there.
so i just wanted to ask yall and also Christian in this question, what are the problems that yall have faced using a parameterised query as a form's recordset?
thanks so much guys!! = ))