Pass filtered form data to a report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can code a form to filter on key data; What type of code would pass the
filtered form data to a report? (Having given up on the idea of mail merging
filtered records).
 
The DoCmd.OpenReport method has properties that you can use to filter reports.

When you use DoCmd.OpenReport just pass the form's filter in the 'Filter'
attribute or maybe in the 'Where' attribute...

You could probably achieve what you were trying to do with your merging.
By using references to controls on your form in the criteria of a query you
can filter the data it returns. If your merge document is based on that
query's output then it will merge with the correct records.

Steve
 
Back
Top