Why not do it?
Personally, I don't use a subform for this. I use a listbox. The listbox has a query as a source. The query refers to the fields for the date range. The code behind the submit-button tells the listbox to requery.
The alternative is to build the SQL-string for the query for the listbox (just a property) dynamically in the code behind the button. Then you don't need to define it in the Query tab.
I have a queryt hat returns data by using a date range suplied by the end user. The end user inputs the date range via a main form.
When the user enters the date range and clicks "Submit" the resulting data set is displyed in the Access default window. I am trying to have the data set displayed in the subform which is located on the main form.
By having a subform display the data the end user can view the data and submit for a differnet date range.