Thanks for your post. Based on your description, I understand that you want
to use parameter in a query using VBA. If I have misunderstood, please feel
free to let me know.
Please check and see the suggestions in the following article:
201493 ACC2000: How to Use ADO to Create a Parameterized Jet Stored
Procedure http://support.microsoft.com/?id=201493
Please feel free to post in the group if this solves your problem or if you
would like further assistance.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.