Pass on a form filter by example to a query

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!
 
A

Albert D. Kallal

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
 
Top