I don't believe they do. Queries are simply SQL statements which display or update data. What are you trying to accomplish? Maq B-)
<insert witty signature here>
I have a form that contains data files that are populated from a query. I'd like to have the form be populated only with filtered records, but I can't figure out how to get the filter to be applied automatically. What about putting an apply filter action in the second form's code? For instance, this is the line that opens the query:
Set rst = db.OpenRecordset("multifamily"
Is there a way to augment that line so that it displays filtered records only?
All you need to do is set the recordsource property of the form to the query.
How is the form being opened? Is it called from another form or macro? If so you can enter your filter criteria in the docmd.openform statement.
Is the filter always the same filter each time you open the form? If so then just enter the filter as part of the query's selection criteria. Maq B-)
<insert witty signature here>
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.