Let me start with an etiquette question - I posted a message similar to this one a week ago that got only one response. I have searched the site to no avail. Is there a "correct" way to ask for more input?
My question is: How do I get the records selected through a "Filter by Form" query to be carried into a report? The form is based on a query linking several tables and any report coming from that form seems to look at the query, rather than the results of the "Filter by Form".
I have placed a command button in the footer of the form (the form displays one line per record) and it works fine if the form is based on a table. But when it is based on a query, the Filter by Form is ignored and all records are retrieved.
Thanks for your help.
Lloyd
My question is: How do I get the records selected through a "Filter by Form" query to be carried into a report? The form is based on a query linking several tables and any report coming from that form seems to look at the query, rather than the results of the "Filter by Form".
I have placed a command button in the footer of the form (the form displays one line per record) and it works fine if the form is based on a table. But when it is based on a query, the Filter by Form is ignored and all records are retrieved.
Thanks for your help.
Lloyd