Linking forms and reports.

[Rose]

I am trying to find the easiest method to write code which would allow me to
open a report from a form linking up to five fields. For example: I have a
form linked to a table that contains hundreds of jobs (tblJobs). In the form
I want to be able to click a command button and pull up a report on the
potential clients (tblClients) who fit the matching criteria in the current
form. The criteria fields may be City, Job Category, Age Requirement, etc.
Any thoughts?

 

[Allen Browne]

The most flexible way is to use the WhereCondition of OpenReport, so you can
use any combination of criteria that the user chose to fill out on your
form.

Here's a really simple example of how the WhereCondition works, using just
one field:
http://allenbrowne.com/casu-15.html

Here's an example that shows how to create the WhereCondition from several
criteria:
http://allenbrowne.com/ser-62.html
That one includes a downloadable example that shows the matching results in
a form. The process for filtering the report is identical.