Can Forms Call a Report rather than a query

[pj33558]

I have asked someone at work with far greater (and recent) experience with Access than I do.

He created a form with a drop down box that contains each member of a group of employees.

The form "calls" a query, runs the query, populates the information, gets spun to SP, dropped into the person's personal SP folder, and emails an alert to the person to let them know it's ready for review.

That'd be fine, I guess, but I have already created reports for each piece of the process. Unfortunately, the reports contain everyone's information (grouped by person).



The queries are a 1st review in the process. Those queries get exported to Excel, reviewed, changes made, and then sent back to the team. I am taking care of the changes by having an adjustment table.

So, my remaining issue is: Is there no means to have the form call the "report" instead of the query?

[June7]

Code can open whatever object you specify.

What query is 'called' and 'run'. SELECT queries do not have to be 'called' and 'run', only action queries (INSERT, UPDATE, DELETE) need this.

[pj33558]

Thank you for your really fast response!!!

Overall, there are 8 pieces of one process. Each piece has its own quirks. The largest piece has two queries:

1st query - takes data streaming from GL via ODBC link and parses it down
2nd query - takes the results of #1, adds in an employee table to get appropriate pay %s for various things can calculates a payment amount for each line item

That 2nd query's results are then exported to Excel for distribution to management and executive teams for review.

Any changes to those items are put into the Adjustments table.

All other queries (there are 7 other pieces of this process) all require ONLY step #2 above. The information is able to be parsed and calculated in one query vs. requiring two.

The results of those queries are likewise sent to management and executive teams for review and changes. And adjustments handled the same way.

The guru at work, made a form which called those queries. Programmed a "GO" button behind the scenes for the process to run.

That code was pointing at the 1st query above and obviously, created issues for the front 3/4 of the process so, I took out the [forms].[a;sdfkj ] out of the criteria in the 1st query.

Which led me to my question now:

I have all 8 pieces of the process done and spun into reports. Those reports are based off the queries (and formatted the way I want).

Couldn't I just modify that VBA code to point to my reports and have the process work that way?

[June7]

Probably. Reports can be exported to Excel or PDF. How useful the Excel file would be depends on the report structure.

However, if any of those queries are SQL actions I would expect they still have to be run before outputting report.