Using Input Box to add Parameter to Query
Posted on 2014-10-24
I have some VBA in Access that runs a query. I want the user to enter a date in an inputbox in order to filter that query.
How do I do that?
I have coded the input box, and that is working. I have Dim'd rptdate as Date and set that equal to what the user puts into the inputbox.
But my SQL is set to just to the name of the query I am using.
Previously, I put the parameter directly into the query in the query builder, but now I want the user to be able to choose.
The Query name is "qry_TO." I am not sure how to work in what the user enters into the box into the query.
My apologies if this isn't reading clearly. So tired!