How to save values in a query

[muppetmad]

I want to add code to a command buttton that when clicked prompts the user for two values (beginning date and ending date). The two value are then used as the begining date and ending date in a query (between...and) and then the query is saved with the two new values. The purpose of this is so that I can create another button that exports the query into a predifined format. But I cannot figure out a way to do that where I do not have to go in and edit the query. I would like this process to be handled by an end through a form rather than have them editing the query in the background.

 

[edtab]

In your "Select" query design (on your DateField criteria), you need to
reference two date fields coming from your form, e.g.:

Between forms!YourformName!BeginDate And forms!YourformName!EndDate

This will filter your data based on the parameters provided by your form.
You can run this query via a command button on your form or in the
after update of your ending date.