Pass on a form filter by example to a query

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I'm trying to create a form that I can filter and then
pass this filtered dataset into a query to get
totals/averages. I call the query from a button on the
form.

Can this be done?

thanks!
 
Where is the results of the query to go?

I can't imagine you just want a query? Do you not want a report?

Just use the filter property of the form when you open the report?

docmd.OpenReport "YourNiceReport",acViewPreview,me.Filter
 
Back
Top